cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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!

Community Support Team
Community Support Team

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.
Highlighted
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