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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Kolumam
Post Prodigy
Post Prodigy

Error when connecting Opportunity standard object from Salesforce to Power BI

Hi All,

 

I have been facing this issue for the past 1 year that when I connect Opportunity object from Salesforce it is throwing me this error. I contacted Salesforce and they told me that this error is coming from Power BI side and that their API version is 29. When I asked power BI they said they don't have work around for this. This is really annoying as everytime I had to extract the Opportunity object into a excel and connect it with power BI and hence it's useless even if auto refresh is enabled. Is there any work around to fix this ? Kindly help. Datasource Error.PNG

 

Thanks

Krishnamurthy

2 REPLIES 2
ReportMaster
Post Patron
Post Patron

Hi @Kolumam were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls data from the SF objects API. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. 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

v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @Kolumam,

When I asked power BI they said they don't have work around for this.

If the Power BI Product Team have confirmed this is still a known limitation, and there is currently no workaround for it, I would suggest you add it as an idea on Power BI Ideas forum and vote it up to improve Power BI on this feature. Smiley Happy

 

Regards

Helpful resources

Announcements
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!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.