Sharepoint Refresh Error

[CHENV]

I'm having scheduled Refreshes of Sharepoint datasource fail intermittently.

The datasets are scheduled to refresh at 8am and don't fail every day.

Processing error:	SharePoint: Request failed: https://xxxxxxxxxx.sharepoint.com/sites/xxxxxxx/_api/contextinfo
Cluster URI:	WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID:	e9affbac-7f6a-4f04-b863-fee4395ea7e8
Request ID:	557f639d-2e31-44b9-9efa-475e56ce82f9
Time:	2021-02-25 22:22:26Z

[CHENV]

Thanks for the thoughts,

We are on Pro and have the credentials set as organisational. We do have a couple of datasets updating at the same time so i've seperated out the refresh schedule to see if that is an issue.

The api seems to be correct in the query editor as well

[Sujit_Thakur]

Dear @CHENV ,
Please select workspace where your dataset is ,
then hover on the data you will see three options just at right side of the name of data set ,

then select schedule refresh setting options and you will land on page given below 

 

then  select edit credentials and login again to your microsoft account as shown below

 if you are using organizational account then please only use organizational option in privacy level .
after this sign in , try refresh and let me know/
this has always worked for me 

Regards 
thakur Sujit

[DebbieE · Accepted solution]

This could be so many things but it could be worth going into your data sources in Power Query Editor and checking the API version. Im sure its ok but I think it should be 14.

are there any other refreshes going on at the same time as 8 AM ? It would be worth making a note of every time it fails and then see if there are other refreshes going on at that time.

This looks interesting if your in Premium https://powerbi.microsoft.com/en-us/blog/announcing-refresh-summary-for-premium-capacity-admins/ This will allow the admin to view all the refreshes happening. 

It seems to be harder to do for Pro because refresh summary isnt available. Thats something else to think about, if you are in Pro or Premium.