Hi,

I fetch data from a Sql DB. Actually I call a procedure, so the code to combine the tables from the server is executed on the Server.

Now I load this into PQ with Query 1, no further Transformation.
Then I create a reference to Query 1 and do the transformation to get my e.g. Dimensions (query 2)
Another reference to Query1 to get the facts (Query 3)

I thought this is the best and fastest way as the data from the SQL is only loaded once. But I recently learned thats not the case and actually Query 2 is performing Query 1 again. See this link https://docs.microsoft.com/en-us/pow...renced-queries

So in this case I run the SQL query actually 3 times ( 1 time for Query1, 1 times each for Query2 and 3 again)

Is there no other way to simplify and really only 1 time download the data from the SQL server?

thanks