Forum Discussion

CHENV's avatar
CHENV
Frequent Visitor
5 years ago
Solved

Sharepoint Refresh Error

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: Reques...
Need Help
  • DebbieE's avatar
    DebbieE
    5 years ago

    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. 

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
5 years ago

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