Forum Discussion
Power BI connected to Salesforce datasource - How to check if query folding is happening ?
yes, that's exactly what it means. Most simple filters are supported, some are transformed from relative to absolute. But anything more complex than that is not currently supported.
It's good enough for incremental refresh.
Hello lbendlin ,
Thanks for this tip ! Some progress .. I used Power Query Diagnostics on the transformation steps.
My transformation steps consists of 1) Filtered Columns 2) Date filter on Rows
I observed the transformation column filter and the Date filter included in the 'data source query' column (in the 'Diagnostics detailed..' table generated ); Ie the datasource query did have these transformations (select column1, column 2 and where date >= clause) .
Does this mean that query folding is indeed happening with Salesforce datasource eventhough the 'view native query' is disabled, I wonder ? What are your thoughts on this ?
My next step is setting up incremental refresh.
Thanks
Super Useryes, that's exactly what it means. Most simple filters are supported, some are transformed from relative to absolute. But anything more complex than that is not currently supported.
It's good enough for incremental refresh.