Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
HamidBee
Power Participant
Power Participant

Direct Integration of Salesforce Data into Power BI Without CSV Export

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:

 

  1. Any direct connectors or services within Power BI that facilitate this integration.
  2. Steps to set up a real-time or near-real-time data feed from Salesforce to Power BI.
  3. Tips for handling authentication securely during this data integration.
  4. Best practices for data transformation or preparation within Power BI after importing from Salesforce.
  5. Any common challenges or pitfalls to watch out for during this integration process.

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!

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @HamidBee ,

 

There are existing connectors in Power BI for Salesforce.

danextian_0-1707552548500.png

Salesforce reports is for access to reports but limited to 2k rows (SFDC API limitation). Consider using Salesforce Objects if more than 2K.

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

5 REPLIES 5
GilbertHall
New Member

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.

ReportMaster
Post Patron
Post Patron

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:

 

SALESFORCE-1.png

 

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:

 

SALESFORCE-2.png

 

 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. 

 

SELECT_DESTINATION_NEW.png

danextian
Super User
Super User

Hi @HamidBee ,

 

There are existing connectors in Power BI for Salesforce.

danextian_0-1707552548500.png

Salesforce reports is for access to reports but limited to 2k rows (SFDC API limitation). Consider using Salesforce Objects if more than 2K.

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.