Forum Discussion
Connecting to Salesforce through Power BI
Hi - We are trying to connect salesforce objects through Microsoft BI and we get the following error :
'DOM PArser is undefined' for one user & 'Unable to get property 'hasOwnProperty' of undefined or null reference ' for another user
Kindly let me know the reason for this error and a solution to fix this.
Thanks,
Sujatha.M
10 Replies
smeenaks,
Do you connect to Salesforce in Power BI Service or Power BI Desktop? If you are using Desktop, what version of Power BI Desktop do you use? Are you able to sign in Salesforce in web browser?
Regards,
Lydia- Hi Lydia - I connect through Microsoft Excel - > Data - > Get data -> From Online services - > Salesforce object I checked the version from the diagnostics(Data - > Get Data - > Query Options - > Diagnostics) - 2.56.5023.1102 32-bit Thanks, Sujatha.M
smeenaks,
What is the result when you use Salesforce object connector in Power BI Desktop ?
Regards,
Lydia
Hi smeenaks were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. 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:
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 smeenaks,
These JavaScript errors occur during Salesforce authentication and may be related to the old embedded browser used by this Excel Power Query version.
I would update Office and Power Query, clear the saved Salesforce credentials, and test the connection in the latest Power BI Desktop. Also confirm that the Salesforce user has API Enabled permission. If the latest Power BI Desktop connects successfully, the issue is likely specific to the older Excel environment.
For a separate Salesforce-to-Power BI path, Power BI Connector for Salesforce by Metrica Software is available here:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577It lets you select Salesforce objects and fields, apply filters, preview the output, and use SOQL when needed.
Cheers,
Metrica Team
