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. 

DebbieE's avatar
DebbieE
Community Champion
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.