Power BI DataFlow and DF Gen2 - Connection to Salesforce failing

[webchris]

Hi all

I am trying to connect to Salesforce from a Dataflow and Dataflow Gen2 and keep getting errors like this:

The data source kind doesn't support the credential type. Data source kind: Salesforce. Credential type: Anonymous.

and:

Credentials are required to connect to the Salesforce source. (Source at https://login.salesforce.com/.)

The same connection and Credentials work fine when connecting from PBIX-File in PBI Desktop.

Any ideas? Many thanks.

Christian

[webchris · Accepted solution]

Meanwhile, this issue seems to be solved. I can run a Gen2 Flow against Salesforce... 

[lbendlin]

What's your rationale to use a dataflow with Salesforce data?  In my opinion a dataset with incremental refresh is much more efficient.  (Yes, there is just enough query folding in SOQL to make that viable). 

[webchris]

Hi

That might be possible, but that is not the question here:

I have an issue connecting to Salesforce to query data where I need help.

This seems to be a problem with Power BI Service.

[lbendlin]

You can't use anonymous. You need to have a Salesforce username and password, or a SSO token  (but that expires periodically, so user/pwd is better)

[webchris]

Hi, I know. And I am logged in to my company account, and in Power BI it says that I am logged in. 

But it does not work...