Forum Discussion
SOQL in Dataflow gen2
Hi lsabetta,
For large volumes of data, a pipeline will be more efficient than PowerQuery will.
That being said, PowerQuery can connect to Salesforce:
Power Query Salesforce Objects connector - Power Query | Microsoft LearnIf you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Power Query does not allow you to write custom SOQL. It does include some mild query folding (you can check from the query diagnostics) but that is strictly limited to the object, and does not include child queries.
Apply object filters, check the folding, and then accept that you have to ingest most of the object before throwing away what you don't need.
You will not be able to recreate a Report Type logic with this.
NOTE: While both SFDC and Power Query are case sensitive, Power BI IS NOT. Always use CaseSafeIDs.