Sharepoint data refresh throwing error.

[mishrg]

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.

[v-haibl-msft]

@mishrg

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

Best Regards,

Herbert

[mishrg]

@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]

@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).

Best Regards,

Herbert

[AnjanaG]

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]

Hi @AnjanaG 

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