Forum Discussion
Table reference and duplicate generate multiple queries
Hi all,
so I have this scenario:
Json datasource from web endpoint
I shall do a single call to the endpoint and return a big flat table, that i want to split in multiple tables.
I should avoid calling the endpoint multiple time due to thorttling policies that may cause the response to pass the 5minutes (inside the endpoint itself) and timeout the response.
I was looking into the option to use a single call and retrieve the big table, then reference\duplicate multiple times to get a decent relations ship structure.
Anyway monitoring the calls to the endpoint I see a connection coming for each duplicate\reference + the original table.
Is there any elegant way to slice the table after the data is downloaded locally from a single connection to the main table?
Tnx Fr
4 Replies
If you call the table once using Power Query and then slice/dice up the table in DAX you will reduce the likelyhood of extra API calls.
I've seen PQ make multiple calls to the datasource when it seems it doesn't need to.
How complex are your data transformations?
- Hi Phil thanks.
I still looking into the transformations, but likely it Will only be something like:
Split table in 4 or 5 different ones
Create some aggregation functions to do simple calculus like evaluating some fields against other.
To say, i can can even keep the table flat, but is probably a 50+ fields and lose readability and make missing a real structure... Unless there is native format for a json response to include a data structure that pbi can parse from the begin as multiple tables structure.
Thanks FrThere is no json feature just yet, although interestingly you can build datasets in the Power BI web service API using JSON structure files.
I can help with the DAX if you like but suggest you give me an example table with what your expected output is and I can suggest how it may be done.
