Forum Discussion
Power BI Dataflows and Salesforce Objects help needed.
We have been using power bi dataflows to refresh about 30 objects from Saleforces for about 2 years successfully. Our setup is an Enterprise grade reporting setup with many datasets and reports usin...
Hi robarbie,
On the 10-query concurrent limit: this is a Salesforce-side governor limit, so no connector removes it entirely. But you can reduce how close you get to it by pulling less data per query - server-side filtering (only the rows/columns each object actually needs) means lighter, faster queries that clear the connection pool quicker, so your staggering has more headroom.
Power BI Connector for Salesforce on AppExchange is one option that handles the filtering on the Salesforce side rather than relying on Power Query folding:
Why it might fit:
- Server-side filtering configured in Salesforce - lighter queries, less pressure on the concurrency limit
- Handles custom objects and large object sets
- No 2,000-row limit on reports (if you mix in report-based pulls)
- 30-day free trial
- Setup docs: https://metricasoftware.com/docs/salesforce/
- Responsive support if you get stuck: https://metricasoftware.com/docs/salesforce/contact-support/
Happy to set up a quick demo on your object setup. Just reach out via the support link.
Cheers,
Metrica Team.