Forum Discussion
Solved
Using "Reference" in Query Editor does not prevent loading base query multiple times
Let's say, i have one huge table "A" that I like to use as a base table/query for 10 other queries that add their own transformations. "Duplicating" the A query obviously ist the wrong desicion: Ta...
Hi Sokon,
I'm afraid that's how the Power Query works in Power BI. How about the Direct Query mode?
Best Regards,
Dale
If you use query duplicate against your database, the server has to run that query 10 times. However, if you use query reference, the server only run it once, and the query would be loaded into Power BI further transformations. If you think your database server can handle 10 large queries, it would be the best option to do so since Power BI transformations can be slow with large datasets