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!
joey
