Forum Discussion
Salesforce objects live connections
The SalesForce Objects connector only supports Import Mode. Neither Live connection nor Direct Query mode are supported.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
That sounds like a lot of effort, and would require you to actually have a field that could be used for the chunking. Our reports usually run in the millions of rows, so chunking these into 2K pieces will get old quickly.
We use UTF-8 CSV exports of the reports, placed on a SharePoint. No row limits, fast ingestion from Power BI.
If you need better real time, use Salesforce Reports as they were intended.
The field that can be used for chunking is "date_updated" or "date_created". It isn't really a problem.
With the approach that I described data would be extracted using Python and blended in Azure before being loaded into the database. As a result, Azure would do the heavy lifting and not Power BI. Even if you have 500 chunks, Azure can handle it. Of course Power BI on it's own can not.
Of course Power BI on it's own can not.One could think that. But it turns out that Power Query filters on the Salesforce Object connector in some scenarios do fold into SOQL queries (even with the "view native query" greyed out). You are right when it comes to Salesforce reports.