cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MartinVollaard Frequent Visitor
Frequent Visitor

Connect Power BI to Microsoft Azure Blob container with shared access signature

Hi all,

 

With data flows you can connect to a Azure blob container in with account key but is there a way to connect to a file in the container with a shared access signature using the data flows in Power BI services? In Power Bi Desktop you can connect directly to json file using the string with signature. 

 

https://XXXXX.blob.core.windows.net/path/file.json?sv=2019-01-01&si=something&sr=c&sig=123456abcdefg...

 

If i'm using this url for a json-file in data flows it either gives me:

 

DataSource.Error: Web.Contents failed to get contents from 'https://XXXXX.blob.core.windows.net/path/file.json' (404): The specified resource does not exist.. (and yes the url is correct while power bi desktop accepts it without issues)

 

Or it keeps asking me for verification whatever I choose.

 

Even copying the query from Power BI Desktop as an empty query in the data flows keeps failing on verification. 

 

So in short: can it be done what I'm attempting or not? If it can be done I would appriciate some feedback in the right direction.

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Connect Power BI to Microsoft Azure Blob container with shared access signature

Hi @MartinVollaard,

 

Are you trying to provide the credentials within the URL? From PG, that flow is not supported for Dataflows, they suggest to use basic authentication instead.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
v-yulgu-msft Super Contributor
Super Contributor

Re: Connect Power BI to Microsoft Azure Blob container with shared access signature

Hi @MartinVollaard,

 

I have emailed to product team to consult this problem. Would update my reply here once I get any response.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartinVollaard Frequent Visitor
Frequent Visitor

Re: Connect Power BI to Microsoft Azure Blob container with shared access signature

Thank you very much so far!

v-yulgu-msft Super Contributor
Super Contributor

Re: Connect Power BI to Microsoft Azure Blob container with shared access signature

Hi @MartinVollaard,

 

Are you trying to provide the credentials within the URL? From PG, that flow is not supported for Dataflows, they suggest to use basic authentication instead.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartinVollaard Frequent Visitor
Frequent Visitor

Re: Connect Power BI to Microsoft Azure Blob container with shared access signature

Hi,

 

Thank you for the answer and the time spent. I was hoping that the shared access signature would be sufficient. Ik have to add the data source in the model for this. Hopefully this will be supported in the near future.

 

Regards

 

Martin

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 315 members 3,519 guests
Please welcome our newest community members: