rg on 28 Sep 2015 20:26:11
Today we can connect to table storage only using the storage account name and the account key.
This is not a nice way, because anyone who has this account name and key can do anything with our data (with VS, or other tools). I’ts especially dangerous when to need to share your data with someone else ..
It would be great to connect to an table storage with Shared Access Signatures.
We could just generate read-only access key to the data stored in the table storage , we can even give an expiry time :)
It would be a nice clean and safe solution!
- Comments (16)
RE: Connect to Azure Tables via Shared Access Signatures
Hi, I followed the directions explained at: https://blogs.msdn.microsoft.com/chmitch/2018/05/31/connecting-to-blob-storage-with-a-shared-access-signature-in-power-bi/.However, using the advanced web connector to connect to Azure Tables via Shared Access Signatures did not work for me. :'(
RE: Connect to Azure Tables via Shared Access Signatures
Would be great to have a straight forward Power BI and Storage Account SAS token integration!
RE: Connect to Azure Tables via Shared Access Signatures
This really should be the preffered way to access the storage tables. Giving out the key to the entire account should not be the default option and using the API as others have mentioned is impractical for large tables when you need the table to be the source. Just implement the SAS and all the problems go away
RE: Connect to Azure Tables via Shared Access Signatures
Hi, you can already do it without limitation using advanced web connector. Everything explain here: https://blogs.msdn.microsoft.com/chmitch/2018/05/31/connecting-to-blob-storage-with-a-shared-access-signature-in-power-bi/.
It's a bit tricky but fully functionnal !
RE: Connect to Azure Tables via Shared Access Signatures
Please see this article if you are still struggling with the rest API row limit, I hope it might help you https://medium.com/@martijnlentink/azure-table-storage-in-power-bi-with-a-shared-access-signature-token-dde6524b01c
RE: Connect to Azure Tables via Shared Access Signatures
REST API restricts access to a single table, and the volume of records. Discouraging to not be able to grant PowerBI limited rights into the storage account.
RE: Connect to Azure Tables via Shared Access Signatures
Hi, REST API works and is very helpful. But I think that maximum number of entities is limited 1,000 because of REST specification.
RE: Connect to Azure Tables via Shared Access Signatures
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
Works for me at least, hope it helps someone else.
RE: Connect to Azure Tables via Shared Access Signatures
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
Works for me at least, hope it helps someone else.
RE: Connect to Azure Tables via Shared Access Signatures
Hi, did this ever get implemented?