Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

azure table storage Data size limit

hello all!

ive written a little console app that hits a sql DB exposed through a rest api . i then grab each record of each table and create a record in a single Azure Table Storage Table with records from table “A” being created with partition key of “A” and records from table “B” being created with parition key “B” and so on.. so all my sql tables are represented by partition keys matching the name of the sql table. Great! now for consuming this table in power bi my idea is that i would create a calculated table from the single azure storage table for each parition key. So in essence i would have a replica (of sorts) of my sql database in powerbi missing relationships of course which would need to be manually created but thats another post 🙂 . could i get some guidance on how to go about this ? Is this possible? would i have to manually create each calculated table (almost 600 tables!) or is there a dax/m query that i could write to say something like “ for each patition key create a calculated table with the rows that match the same partition key”

i hope this question makes sense and look forward to hearing your feedback!

Regular Visitor

sorry about the title im not sure how that happened. should have read “ azure table storage calculated table for each partition key”

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Kudoed Authors