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

[MartinVollaard]

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!

[v-yulgu-msft]

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

[MartinVollaard]

Thank you very much so far!

[v-yulgu-msft · Accepted solution]

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

[Shawn_Eary]

I would like to maybe use a Shared Access Signature to connect from Power BI to Azure Table Storage, but I don't see that as an option.  As far as I can tell right now, I only see the option to specify the full storage key when connecting Power BI to an Azure Storage Table.  I'm guessing using a Shared Access Signature might be a little more secure.

[MartinVollaard]

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