Looking for a more elegant way to load my tables

[Anonymous]

Hi,

I'm extracting data from an API containing financial data for which I first have to send a query to select the desired administration. The company for which I'm doing this has 5 administrations. 

The sequential queries look like this data1 -> select2 -> data2 -> select3 -> etc

I've disabled the parallel loading of tables to get the required result. I need the select queries to run before the corresponding data query. 

This results in 10 tables being loaded to my report, and this is only the financial data. More data is to be added in the future. Is there a more elegant way to do this? If I merge the data queries in power BI the select queries are not executed and I get 5 copies of the same administration. Any ideas?

[v-piga-msft]

Hi @Anonymous ,

I have a little confused about your scenario.

Please check if the query parameter will help your load the data better.

Best  Regards,

Cherry