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: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎10-18-2017 12:11 AM

@JoshuaHoward

 

Same issue was reported internally to Power BI Team: CRI 38910695
And the product team are looking into it. I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎10-18-2017 12:17 AM
Status changed to: Accepted
 
JoshuaHoward
Advocate I
Advocate I
‎10-19-2017 05:47 AM

Hi Herbert,

 

May I ask how long this has been an issue and when we expect this to be resolved?

 

Thank You.

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎10-30-2017 06:54 PM

@JoshuaHoward

 

I’ve got response from the Product Team.

 

In the most recent example, the Salesforce service is returning an HTTP 403, meaning "this account does not have permission to perform this operation". We don't know why Salesforce would return this error, and customers may need to contact Salesforce support to find out why.

 

Best Regards,
Herbert

k3rz0rg
Advocate III
Advocate III
‎12-01-2017 01:01 PM

I'm having problems with salesforce connections for quite a while. It's been about more than 7 months salesforce connections in different reports keep dropping and auto refresh keeps failing.

Everytime I need to check my refresh failure mail and reset the connection providing the same credential and it fails again on the very next refresh.

I do not know at which point it is failing, on salesforce or power bi gateway and cannot go through the log as well since the connection is direct.

I strongly hope Microsoft will focus in this issue.

 

Update: Yup, for past 2 days I am facing the exact same issue... No more login anymore and credential invalid error... 

 

- K3

JoelPendery
Frequent Visitor
‎12-04-2017 09:29 AM

I too am having this issue. I am receiving an error that "The credentials provided for the Salesforce source are invalid." when they are not (Status: 400 error). I can sign into Salesforce online with the same credentials and connect to my reports from Power BI Desktop and refresh the datasets from there. I cannot sign in from Power BI Service. I have already spoken with Salesforce technical support and based on the login activity of Salesforce, the login from Power BI Service is successful. I am still getting the error on the Power BI Service side saying the credentials are incorrect (when they clearly are not). I hope this issue is fixed quickly.

AnshuPrakash
Regular Visitor
‎12-05-2017 09:30 AM

Having the same issue exactly - this needs a fix asap.

v-qiuyu-msft
Community Support
Community Support
‎01-25-2018 05:39 PM

Hi all,

 

I got information that it works if the account is an saleforce developer account. Please check which kind of Salesforce do you use? Thanks. 

 

Best Regards,
Qiuyun Yu 

 

jjwleiden
New Member
‎02-07-2018 05:51 AM

Hi,

 

I have the same issue; we have Salesforce Professional edition without API access. Refreshing in the online version of PowerBI does not work; however manual refresh on the desktop version of powerbi works fine.

 

PowerBI is a great tool to see business performance; but an automated update of data is essential in order to use it. As about 50% of our data is in Salesforce making this work would be of great value to us-- basically it's what stops adoption of PowerBI now as it can only function as a stand-alone tool, not as a way to keep the company informed.

 

 

 

NNick
Regular Visitor
‎02-08-2018 05:53 AM

Same issue here, I can refresh the report through the desktop version, but not through app.powerbi.com. Any suggestion how to solve this annoying situation? Connecting directly to SalesForce. I also tried to use the security token together with my password, but that did not went through. Thanks in advance!

Nik

Idea Statuses