Getting data from Azure Table Storage using Shared Access Signature

[cbaekdorf]

When using Microsoft Azure Table Storage (in Power BI Desktop) as data source I have to use shared secret authentication which means that I will have to expose the shared secret for the entire storage account.

Is there a way to use a shared access signature (e.g. using a SAS url like https://xxxxx.table.core.windows.net/yyyyy?sv=2014-02-14&tn=yyyyy&sig=%2BwEklvHzicH6b020K1u0kIJhNC6f... to give limited access to a specific table?

If this is not possible in the current version, I think it should be added in the future. It’s the only way to manage access to Azure Table Storage.

[WillT · Accepted solution]

Hi - no, this isn't available in the current version. But it's a great suggestion, please submit it on http://ideas.powerbi.com and we'll track it with everything else! Thanks!

[RahMan911]

Hi,

Did this eventually get implemented?

[mhardy]

Not yet.  However the idea is posted here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9953427-connect-to-azure-tables-v...

Please vote.

In the meantime Scott Christian has posted a workaround using REST:

This can be done already, it's just not overly obvious as it needs to be done via the REST API. 
PowerBi -> Get data -> from web -> advanced: 
URL Part 1: https://SOMEACCOUNT.table.core.windows.net/ 
URL Part 2: SOMETABLE/ 
URL Part 3: *FullSASToken* for example (?sv=2017-11-09&ss=bfqt&srt=sco&sp=rwdlacup&se=2018-10-11T07:59:01Z&st=2018-10-10T23:59:01Z&spr=https&sig=BLABLABLAsomeSIG) 
Header -> Accept: application/json;odata=nometadata

I have found this to work but has the issue of 1,000 maximum records per single REST request being returned:

https://docs.microsoft.com/en-us/rest/api/storageservices/query-entities#remarks