Hi SF professionals,
I'm relatively new to Salesforce and currently working as a Salesforce admin. My client is interested in integrating Salesforce with Power BI. Current situation is, we've encountered an issue with our current Salesforce license, which restricts us to extracting only 2000 rows from Salesforce to Power BI.
We're exploring the possibility of purchasing other Salesforce licenses that offer greater flexibility, allowing us to extract more rows beyond the current 2000-row limit. While we're aware of the availability of various third-party apps, my client specifically wants to know the options available directly from Salesforce and compare them.
I've reached out to my account executives with this query but never received a response. I'm hoping someone here might be able to provide information on this matter or direct me to where I can find it.
Thank you in advance for any assistance you can offer.
Hi @Lynn Li
,
Another option worth considering is the
Power BI Connector for Salesforce, available on Salesforce AppExchange: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577- It directly solves the 2,000-row limit issue
- It lets you define data sources (selecting specific objects, fields, and filters) inside Salesforce, then exports them to Power BI via OData
- The setup is no-code: install the AppExchange app, create a data source, and paste the generated Power Query script into Power BI
- It supports incremental refresh, handles custom objects and relationships, and respects Salesforce permissions, so access control stays consistent
- It allows unlimited reusable data sources, which helps when reports need to be run frequently across multiple use cases
- It's installed directly within your Salesforce org, which keeps things within the Salesforce ecosystem and simplifies security review
There's a free trial if you want to test it before committing. Hope this helps!
