Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi,
Did this eventually get implemented?
Not yet. However the idea is posted here:
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
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |