Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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

JoshuaHoward

Salesforce data refresh with invalid credentials

Submitted by Advocate I on ‎10-17-2017 08:00 AM

Hi,

 

I've been experiencing an issue where I cannot refresh the dataset from the Saleforce data source in the Power BI service. While I am in Power BI desktop I am able to refresh the data without issue. While I am in the Power BI service, if I navigate to Settings > Datasets > Report Dataset Credentials, I am shown an error that tells me that the credetials are not correct. Even attempting to re-enter the credentials from this page does not allow the account to accomplish login.

 

First I select Settings > Datasets > Report.  You can see below the salesforce credentials are not working correctly.

 

1.jpg

 

I then click on edit credentials next to sales force and this is the pop up. OAuth2 is the only authentication method possible to select.

 

2.png

I click sign in and this pops up.  I then type in the username and password and click login.

 

3.png

After I click login I get this error that pops up.

 

4.png

 

The entered credentials are correct and should not return an issue.

Status: Accepted
See more ideas labeled with:
16 Comments (16 New)
Comments
pftcg
Advocate I
Advocate I
‎02-20-2018 01:33 PM

Any updates with this?

 

I'm surprised this hasn't been resolved yet. I would imagine fixing automatic refresh with Salesforce is a high priority.

k3rz0rg
Advocate III
Advocate III
‎02-21-2018 07:35 AM

After talking to both parties, salesforce and microsoft support; the only resolves I was able to find from microsoft were 

-use only one link per report, even if you are working with multiple tables, recreate the report fetching multiple tables at once (which is absurd for incremental reports).

-disable single sign on (which is another absurd idea because it might conflict company policy since this feature affects the entire salesforce users).

 

Luckily for me, we do not use SSO for my company and recreated the report fetching 3-4 tables all at once so that only one link is used this time rather than multiple; for me it is working however if it goes incremental, according to my previous experience, I can guarantee that issue will recur since no party guaranteed that the connector have been updated or so.

 

-K3

inescm
Regular Visitor
‎07-20-2018 05:20 PM

We have the same issue - after a back and forth of calls and emails with MSFT & Salesforce, they came to the conclusion that the issue is using the Professional Edition of Salesforce.

phanpt
New Member
‎03-06-2019 09:09 AM

I got the same issue today, 3/6/2019.   Get error when refresh data on Power BI service to Salesforce

wensdayh
New Member
‎10-09-2019 08:22 PM

i got the same issue at 2019-09-30. And it work ok before 2019-09, i do not know what happend at 2019-09-30...

Anonymous
Not applicable
‎03-27-2020 08:53 AM

I am receiving this error even now, years after the original post. I can refresh my SalesForce data in Desktop but Schedule Refresh does not work in Service due to "Invalid" SF credentials (which are not invalid). I don't think we can justify upgrading to SF Enterprise at this time and I do not want to continue to manually refresh and re-upload the report daily.

 

Are there any other options available yet to allow a Scheduled Refresh for a report that contains both on-premisis data and data in an online standard Professional SalesForce Account?

 

Thank you

Idea Statuses