Connection to Azure Tables & connection location

Hi rluismendes ,

1. Power BI connects to Azure Tables using shared access signatures.

Using shared access signatures isn't available in the current version. But it's a great suggestion, please submit it on: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9953427-connect-to-azure-tables-v...

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

This to work but has the issue of 1,000 maximum records per single REST request being returned. The API makes use of some kind of pagination where the rest of the results can be retrieved in subsequent requests. The API requests returns headers with continuation tokens which we should provide in our next request. Martijn Lentink's article gives detailed steps and code: Azure Table Storage in Power BI with a Shared Access Signature Token 

2. Storage location of your credentials.

You are right. The credential for the data source are encrypted and stored on the machine which have the .pbix created C:\Users\<user name>\AppData\Local\Microsoft\Power BI Desktop\User.zip.

Refering: Query Editor requires credentials? 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.