Forum Discussion

Ray_Brosius's avatar
Ray_Brosius
Helper III
5 years ago

SharePoint: Request failed: _api/contextinfo

I have a Power BI dataset that reads in a large number of csv files from a SharePoint Site.  I have it refresh only once a day.  the refresh fails almost everyday now.. it runs perfectly fine on my desktop ..  There is a single file in this folder... I am using the out of the box SharePoint FOlder connector to read in files from this folder and several others.  The other folders have a lot of files and I combine them all... 

 

The error is not consistent, in that sometimes I just restart the refresh and it works... 

 

Hide
Scheduled5/12/2021, 6:02:45 AM5/12/2021, 6:20:32 AMFailedThere was an error when processing the data in the dataset.
Processing error:SharePoint: Request failed: https://OURSITE.sharepoint.com/sites/SITENAME/Shared Documents/Owner_Data/Owner_Data0_csv/_api/contextinfo
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:f88e5ae3-feec-4548-a7d4-fd5eb8eca19f
Request ID:a3dfaf29-0d71-4217-b7e4-fd0661e98e11
Time:2021-05-12 10:20:32Z
Need Help

1 Reply

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Ray_Brosius ,

     

    I can't reproduce your issue. Would you please try to clear the  SharePoint credentials in power bi desktop and recreate it again? (File->Options and Settings->Data Source Settings->Clear Permission)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai