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: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

0
mishrg

Sharepoint data refresh throwing error.

Submitted by Advocate I on ‎03-01-2017 12:31 PM

I created a report from power BI Desktop connecting a sharepoint list with Windows authentication and published it. 

 

I am getting the following error when I am setting up the data refresh from power BI service. 

 

"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."

 

There is an option to edit credentials but I am getting only two options: Windows and Anonymous. By default it is set to Anonymous.

 

And on changing to Windows, it is throwing the following error.

 

Failed to update data source credentials.Hide details

Activity ID:967be40c-bc0a-41b8-8948-0e9ef9f99d15
Request ID:4eb0dfbf-ef6d-59d0-4525-484dc1ea2826
Status code:400
Time:Wed Mar 01 2017 12:28:38 GMT-0800 (Pacific Standard Time)
Version:13.0.1700.1256
Cluster URI:https://wabi-west-us-redirect.analysis.windows.net

 

 

Can anyone help me out with this. What needs to be done here.

Status: Delivered
See more ideas labeled with:
7 Comments (7 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎03-02-2017 11:27 PM

@mishrg

 

Is gateway used here? Can you refresh the dataset properly in Power BI Desktop with the same Windows authentication?

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎03-03-2017 12:23 AM
Status changed to: Needs Info
 
mishrg
Advocate I
Advocate I
‎03-03-2017 08:06 AM

@v-haibl-msft Yes I am able to refresh from Power Bi desktop. No there is no gateway used here, since I am connecting to a sharepoint online list, not an on-premise sharepoint list.

 

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎03-08-2017 12:53 AM

@mishrg

 

It is strange that there is no OAuth option on your side. I can use the OAuth authentication method and refresh the dataset properly as below.

I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

 

Sharepoint data refresh throwing error._1.jpg

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎03-08-2017 12:55 AM
Status changed to: Delivered
 
AnjanaG
Regular Visitor
‎06-06-2017 12:57 AM

Hi @mishrg,
 
I had the exact same issue and the edit credentials had only 2 options (Anonymous & Windows).

 

The problem was with the URL. Click edit credentials and check if the "SharepointSiteUrl" starts as https:// as mine was http://. I changed it to be https:// in the powerBI desktop file and republished it after which edit credentials came up with 3 options (Anonymous, Windows and OAuth2). I selected OAuth2 and everything was working.
 
Regards,
AG

qamarulhassan
Regular Visitor
‎06-26-2021 11:14 PM

Hi @AnjanaG 

I had the same issue. Thank you so much for your tip. Issue resolved!

Idea Statuses