Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Refreshing dataset (webservice) with SharePoint source

Do more people get this error with the refresh of a dataset in the power bi service? When I look at the references (login) I do not have a login error.

 

I can publish my PBIX, but refreshing fails everytime.

 

Also when I refresh these references and then again load the dataset, I still get this error message. Someone the golden tip how to fix it?

 

First I got it for another dataset, removed it for testing. But this does not help either. He then simply switches to another dataset with the error.

 

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

MessageThe credentials provided for the SharePoint source are invalid. (Source at https://xxxxxx.sharepoint.com/sites/xxx) Table: xxx
Cluster: URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity IDa7415de3-7a8b-4f7e-8ff2-e96b9245b130
Request ID7e22d890-ed52-33ab-c1fe-4f7ab2507fcd
Time2019-02-14 12:36:17Z
Status: New
Comments
v-qiuyu-msft
Community Support

Hi @haassiej ,

 

Please go to Dataset Settings and enter the valid credential for SharePoint data source. If it's connecting to SharePoint online, please choose OAuth2 authentication type. 

 

q2.PNGq3.PNG

 

Best Regards,
Qiuyun Yu