Forum Discussion
Query Loading Order
How does Power BI determines the order of queries loaded in the data model? Is it determined by the order of sources you get?
Hi Anonymous,
It looks like nothing special loading queries. The queries can be loaded concurrently.
Best Regards,
Dale
9 Replies
Hi Anonymous,
It looks like nothing special loading queries. The queries can be loaded concurrently.
Best Regards,
Dale
I was thinking the exact same thing.
I have a model that has evolved over time. It now takes about 10min to load all the data.
One of the tables is a single row, Last Refresh table, that reports on the currency of the data.
Being small, this table is always one of the first to load, and that means the Last Refresh time stamp is always a little bit out.
It's not a big issue, but it would be nice if there was some way to flag that this table should load last.
Well that maybe, but that doesn't answer the question. Why this is marked as the solution baffles me.
Netrelemo , I notice a lot of 'solutions' like this. A question is posted "How do I do this?" and someone replies "You can't" and the reply is marked as a soluton 🙄
Hi v-jiascu-msft , queries that have a dependency on each other cannot be loaded concurrently. For example, limiting the date table based on max date in the FACT table cannot load concurrently. It even throws an error sometimes about it but no consistently.
The error wording is: Query 'Query Name' (step 'Step Name') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Again, this is inconsistently coming up in PBI desktop.
