Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey folks, I can't find the answer to this in the docs, so maybe someone here can clarify. I have a Power Query script that pulls data from a SQL Server table. Call this query A. This query folds just fine as indicated by the fact that I can view the native query in PQ. If I create a new query that references the query A (call this one query B), I can't view the native query. Am I correct in assuming that the reference to query A breaks folding for query B?
We use a stage/load pattern for all of our PQ development where we stage untransformed tables but don't load them to PBI. We then do any transformations against a reference to the staged table and then load the transformed table to PBI. If this breaks folding then we'll need to rethink our approach.
Thanks!
Solved! Go to Solution.
Not being able to view the native query doesn't always mean that it won't fold. In this case, I think it probably is still folding but just isn't generating the native query preview. Try adding a simple filter step after referencing and see if it shows the native query option or not (this works for me on a simple example I just tried).
For more on this, I recommend this Guy in a Cube video:
https://www.youtube.com/watch?v=QEFze-LdLqo
(You can skip the first 3 minutes to jump right to the relevant part.)
Not being able to view the native query doesn't always mean that it won't fold. In this case, I think it probably is still folding but just isn't generating the native query preview. Try adding a simple filter step after referencing and see if it shows the native query option or not (this works for me on a simple example I just tried).
For more on this, I recommend this Guy in a Cube video:
https://www.youtube.com/watch?v=QEFze-LdLqo
(You can skip the first 3 minutes to jump right to the relevant part.)
Thanks, Alexis - I tested as you suggested and you're right, query folding is still in effect.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.