Salesforce connection from Power BI Service dataset

[jcody]

I have no problems connecting to Salesforce Reports/Objects from Power BI Desktop, but when I publish the dataset to the Power BI Service, I am unable to connect to Salesforce. I have verified that I can log into Salesforce without problems. I'm sure there is some combination of settings between Power BI and Salesforce that need to be tweaked, but I have not been able to find the answer online.

Failed to update data source credentials: The credentials provided for the Salesforce source are invalid. (Source at https://login.salesforce.com/.)Hide details

Activity ID:	51e77330-e870-415b-9fe5-ada0de559a0c
Request ID:	ff0df9f9-9c21-97b6-81d0-a1d3690509bd
Status code:	400
Time:	Sat Aug 08 2020 09:10:37 GMT-0500 (Central Daylight Time)
Service version:	13.0.14066.66
Client version:	2008.1.02249-train
Cluster URI:	https://wabi-us-east-a-primary-redirect.analysis.windows.net/

[lbendlin]

I have never seen someone use Microsoft Authentication against SFDC.  Are you sure that's how you login? The service likely won't know which Microsoft account to use.

[jcody]

"Microsoft Account" is the only option available in the dropdown. When I go to authenticate, it opens the Salesforce login dialogue box and I am able to successfully authenticate. However, when I click "Next" I receive that error message.

I've opened a ticket with Microsoft in the meantime and they are investigating.

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".