Tuesday, 2 May 2023

To Move TB or PB of data in Azure

Scenario - To move TB or PB of data in Azure 

 Use the following table to estimate the time and based on that, choose between an offline transfer or over the network transfer. The table shows the projected time for network data transfer, for various available network bandwidths (assuming 90% utilization).

Network transfer or offline transfer

  • If the network transfer is projected to be too slow, you should use a physical device. The recommended options in this case are the offline transfer devices from Azure Data Box family or Azure Import/Export using your own disks.

    • Azure Data Box family for offline transfers – Use devices from Microsoft-supplied Data Box devices to move large amounts of data to Azure when you're limited by time, network availability, or costs. Copy on-premises data using tools such as Robocopy. Depending on the data size intended for transfer, you can choose from Data Box Disk, Data Box, or Data Box Heavy.
    • Azure Import/Export – Use Azure Import/Export service by shipping your own disk drives to securely import large amounts of data to Azure Blob storage and Azure Files. This service can also be used to transfer data from Azure Blob storage to disk drives and ship to your on-premises sites.
  • If the network transfer is projected to be reasonable, then you can use any of the following tools detailed in High network bandwidth.




Tuesday, 14 March 2023

Sort on multiple columns Power BI

 Hi All,

To be able to apply sort on multiple columns in Power BI on Power BI desktop

1. Apply desired sort on first column

2. Then hold the shift key and apply sort on the second column 

3. Hold shift key and apply required sort on next column


Bingo...data is sorted

Monday, 13 March 2023

Power BI connecting to Azure Gen 2 - Access to this resource is forbidden

 Hi All,

While connecting from Power BI to Azure Gen 2 we encounter the below error 

Access to this resource is forbidden

To resolve this issue follow below steps

1. Check if Storage Blob Reader access is provided

2. In Power BI, click on options, clear permissions for already exisiting connection and then try again

This time sign in 

3. If you still get the same error, log on to the container using Azure storage explorer and the get the dfs url and not the windows.net url


Bingo issue fixed !!