I hope someone can help. I'm running various queries with different expected results on the same SQL Server data table. The problem is that the dataset is quite large. At the moment each of the queries fetches the same dataset each time making the refresh extremely inefficient. Is there a way to retrieve the data once from SQL and then run the various queries using the same dataset?
No. In Power Query you should essentially expect at least one source hit per query. This is true whether you duplicate or reference queries with the same source.
I would probably recommend bringing the data in only once with Power Query and differentiating your required outputs using DAX measures.
Pete
Now accepting Kudos! If my post helped you, why not give it a thumbs-up?
Proud to be a Datanaut!
Helpful resources
Announcements
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
