Hey everyone I am trying to connect Powerbi to my data lake gen 2 on azure I am set as Storage Blob Data Contributor Aswell as Storage Blob Data Reader on the Storage account level i am not sure if I am doing something wrong but I also used the MS docs yet nothing https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage
The URL is formatted according to this format https://.dfs.core.windows.net//
CodePudding user response:
To resolve Access to the resource is forbidden
error, try following ways:
- As suggested by Etienne Oosthuysen, check the date-time settings of your system.
As per documentation:
Only this format is supported
https://<accountname>.dfs.core.windows.net/<container>
It doesn't support filename or subfolder like this,
https://<accountname>.dfs.core.windows.net/<container>/<filename>
orhttps://<accountname>.dfs.core.windows.net/<container>/<subfolder>
You can refer to Get Data from Azure Data Lake Gen 2 : Access to the resource is forbidden