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.
Hi All,
Appoloies if this is noted elsewhere
Does query folding work with Amazon Web Services (AWS)?
Regards,
Mathew
Hi @101Mathew,
You could check if Query Folding is active by checking for the existence of Native Query code inside that step.
When you use Power Query, the steps you produce are listed in the right side “applied steps” panel, right-click on one of the query steps and then select “view Native Query”. If you are able to do this, ie if view Native Query is enabled, it means Power Query has successfully performed query folding.
Reference:
How do I Know if Query Folding is Active?
Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform
Best regards,
Yuliana Gu
Thank you for that tip, out IT dept. are looking to use AWS, so I don't currently have anything to test against.
Cheers
Mathew
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.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |