How to select a specific container in Azure Blob Storage using Power BI?

Question

How to select a specific container in Azure Blob Storage using Power BI?

Julia 0

Hi,

I am trying to connect data that is currently stored in a container in Azure Blob Storage to Power BI. However, using the in-build connector, I get multiple containers, which I do not need, and I am unable to navigate further through the sub-containers. I ideally would like to connect Power BI only to one specific container, which is located in one of the sub-containers.

Is there an "easy" way to force Power BI to navigate through several sub-containers [using Power Query maybe?] and then select 1 specific container from there?

Pleased to hear back from you soon.

Thank you a lot in advance.

Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-11T07:07:37.85+00:00

Julia

Just checking in to see if the below comment answers your query. please let us know if you have any further query.
Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2023-09-12T07:34:44.2033333+00:00

@Julia Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-13T15:10:23.57+00:00

Julia Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-14T14:10:13.1366667+00:00

Julia

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-20T05:13:13.18+00:00

Julia Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Your answer

Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-11T07:07:37.85+00:00

Julia

Just checking in to see if the below comment answers your query. please let us know if you have any further query.
Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2023-09-12T07:34:44.2033333+00:00

@Julia Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-13T15:10:23.57+00:00

Julia Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-14T14:10:13.1366667+00:00

Julia

Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Ramya Harinarthini_MSFT 5,366 Reputation points Microsoft Employee Moderator

2023-09-20T05:13:13.18+00:00

Julia Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Julia • Apologies for the delay in response!!

To navigate to a specific Azure Blob storage container from Power Query tool Please follow the below steps.

From MS Excel click on Data -->Get Data --> From Azure--> From Azure Blob Storage

User's image

Next Step is to provide Azure Blob storage container URL

To get the container url navigate to Azure Portal-->Storage account-->containers-->select the container that you want to connect to-->select the container properties as shown in below screenshot. User's image

Copy the container url and paste this URL in the Power query.

User's image

Generate the SAS token on the container level with required permissions and expiry and copy the Blob Sas token as shown in the screenshot

User's image

From the Power Query Paste the Container URL and select Okay User's image

Now select the shared access signature to authenticate and paste the Blob sas token generated previously and from the drop down select the Container URL to connect

User's image

Now you will only be able to see the blobs inside that container.

User's image

Kindly let us know if the above steps helped.

Share via

How to select a specific container in Azure Blob Storage using Power BI?

1 answer

Your answer