Forum Discussion
Reference Table loaded multiple times
Hello everybody, I have a big problem with the performance for queries I wrote in Power Query. To get to know you first: Evaluation of the queries is made in Excel and not in Power BI. I have to...
Hi Anonymous ,
The surefire way to stop a query loading multiple times is to load it only once.
I'm not being a smartarse - if the multiple loads are causing you significant performance issues, then remove all the referenced queries, strip back to your core query, then handle the rest within the Excel Data Model (exactly as you would in Power BI).
Without seeing your queries and data it's difficult to say whether everything you want to do in subsequent queries is feasible/possible within the model, but certainly things like merges between queries can be removed via Data Model relationships, and so on.
Pete