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 !!