Microsoft Power BI Cookbook
上QQ阅读APP看书,第一时间看更新

Query folding

The query from this recipe was "folded" into the following SQL statement and sent to the ATLAS server for processing.

Figure 10: The SQL statement generated from the DimGeography M query

Right-click on the Filtered Rows step and select View Native Query to access the Native Query window from Figure 11:

Figure 11: View Native Query in Query Settings
Finding and revising queries that are not being folded to source systems is a top technique for enhancing large Power BI datasets. See the Pushing Query Processing Back to Source Systems recipe of Chapter 11, Enhancing and Optimizing Existing Power BI Solutions for an example of this process.