Question 105980 in Azure Question posted in
The official documentation to get you started can be found here.

Connecting power bi to Azure data lake gen 2

enter image description here

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://learn.microsoft.com/en-us/power-query/connectors/datalakestorage

The URL is formatted according to this format https://.dfs.core.windows.net//

Tags:

2

Answers


  1. 0

    To resolve Access to the resource is forbidden error, try following ways:

    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> or https://<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

    Login or Signup to reply.
  2. 0

    After disabling both Enable soft delete for blobs and containers in azure storage account connection issue was resolved.

    To Change Settings
    Go To Azure storage account —> Data Protection—>Disable soft delete for blobs/Enable soft delete for containers

    Reference image

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search