Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
I'm exploring efficient ways to integrate Salesforce data directly into Power BI for our analytics and reporting needs. Currently, our process involves exporting data from Salesforce into CSV files and then importing these files into Power BI. This method, while functional, is quite time-consuming and introduces a delay in reporting, potentially leading to decisions made on outdated information.
I'm interested in any advice or best practices on how to streamline this process by pulling data directly from Salesforce into Power BI. Specifically, I'm looking for guidance on:
I appreciate any insights, experiences, or resources you can share that would help in setting up a more efficient and automated data flow from Salesforce to Power BI.
Thank you!
Solved! Go to Solution.
Hi @HamidBee ,
There are existing connectors in Power BI for Salesforce.
Salesforce reports is for access to reports but limited to 2k rows (SFDC API limitation). Consider using Salesforce Objects if more than 2K.
Proud to be a Super User!
You can leverage Skyvia to integrate Salesforce with Power BI in two main ways. First, you can replicate your Salesforce data to a data warehouse and subsequently connect it to Power BI. Alternatively, you can expose your Salesforce data as an OData endpoint that Power BI can directly consume. Both methods facilitate seamless data sharing and analytics.
Hi @HamidBee I currently connect my Salesforce data using a 3rd party connector which is windsor.ai. Main reason is because that tool gives me apart from Salesforce many other connectors that doesn't have native Power BI integrations, so in my case it's worth the price. This connector also lets me set up incremental refresh on Power BI side and my report is refreshes automatically every day on PBI servie. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:
After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:
There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
Hi @HamidBee ,
There are existing connectors in Power BI for Salesforce.
Salesforce reports is for access to reports but limited to 2k rows (SFDC API limitation). Consider using Salesforce Objects if more than 2K.
Proud to be a Super User!
Has anyone faced issues of getting a blank data table when using Salesforce objects of Lead and Opportunity to export in Power Bi?
Thanks alot for the information.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |