How Power BI Desktop/ Service connect with Blob Storage Private container using SAS Token

Question

Hi All,

we have once issue, when we change Azure blob storage container to private we are unable to connect using SAS Token.

please suggest how we connect Power BI to Azure Blob when container is private.

Answer 1

Hello manish verma,

Thank you for posting your query here!

When connecting Power BI Desktop or Power BI Service to an Azure Blob Storage container that is set to private, you can use a Shared Access Signature (SAS) token for authentication. Here’s how you can do it:

1. Power BI Desktop:
   • Open Power BI Desktop.
   • Go to Get Data and select the Web option.
   • In the advanced view, enter the base URL of your Azure Blob Storage account in the first box.
   • Put the SAS token in the second box.
   • Add the following string to the third box: &restype=container&comp=list. This allows you to list all the blobs in that container.
2. Power BI Service:
   • In your Power BI workspace, create a new Dataflow or Dataset.
   • On the “Choose data source” page, search for your data source (e.g., “Azure Data Lake Storage Gen 2” or “Azure Blobs”) and select it.
   • In the Authentication kind dropdown, choose the Shared Access Signature (SAS) option.
   • Proceed with the rest of the data transformation as usual.

This approach should allow you to securely connect to your private Azure Blob Storage container using Power BI.

Do let us know if you have any further queries. I’m happy to assist you further.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.