Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am connecting Power Bi to Salesforce using Power Bi Salesforce Object Connector. My aim to establish incremental refresh. Since incremental refresh in Power Bi requires Query folding , how do I check if query folding is happening with my Salesforce data ? Is there any tool to trace the query sent back to Salesforce from Power BI.
Please note in this case , the 'View Native Query' option in Power Query is greyed out.
Solved! Go to Solution.
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.
Hi @KV_PowerBI ,
If the View Native Query option is not enabled (greyed out), this is evidence that all query steps cannot be folded. However, it could mean that a subset of steps can still be folded. Working backwards from the last step, you can check each step to see if the View Native Query option is enabled. If this is the case, then you have learned where, in the sequence of steps, that query folding could no longer be achieved.
You could reference the document below to check if the transformations that can be query folded.
Transformations that can achieve folding
And this blog may help you as well.
@v-xuding-msft Query folding for Salesforce objects is not currently indicated through the View Native Query link. It can only be observed the way I described. Hopefully this will be improved in the future, together with custom SOQL query support including subqueries. That would finally give us the possibility to recreate ReportTypes in SOQL.
You can see it when you run diagnostics on your Power Query transformation step. You can also see it in Fiddler or in the Dev tools on Chromium browsers.
Note that things like YESTERDAY or LASTDAYS:10 are not supported directly. Power Query will translate that into absolute dates for the SOQL. Still works.
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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
65 | |
61 | |
23 | |
18 | |
12 |