Forum Discussion

shabo's avatar
shabo
Frequent Visitor
5 years ago

SharePoint file randomly gives error when refreshing

Hello,

I have a problem we are loading data from files which are stored on SharePoint but when trying to load them to PBI, it gives error on random files (we have total of 40 files on the SharePoint).

 

Tried to clear permissions

Change the ApiVersion

 

But still getting issues saying request failed, and refering to /_api/contextinfo

 

 

Any ideas?

 

Need Help

5 Replies

    • shabo's avatar
      shabo
      Frequent Visitor
      5 years ago

      Hi,

      I used SharePoint Folder which gave me SharePoint.Files when looking at the Advanced Editor.

       

      One additional point to add is that we also have data coming from a  SQL Server which we are doing a append with the files from SharePoint. We have tried to not append them and have them seperat but it gives us still the same issue.

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    For the fun of it you should try to switch to Sharepoint.Contents() at API 14. It may or may not give you anything different.  We ended up bombarding Microsoft with Pro tickets until they fixed something in our Sharepoint tenant, but we still see that error occasionally.

    • shabo's avatar
      shabo
      Frequent Visitor
      5 years ago

      Can try that, we did try to change it to Auto but that didnt give us anything. Assuming you mean the ApiVersion?

       

       

      I also asked the maintenance partners to see if there is something in the setting in SharePoint if that can help us to get forward.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi shabo ,


    According to your problem. Try the following operations: 

    workaround1:

    Make sure that the desktop you are using is the latest version, some similar problems may be caused by the version

    workaround2:

    If not work, please delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.

     

    If the problem is still not solved, you can check the solution of this case, which is similar to the situation you encountered: Solved: Connecting to SharePoint Folder error - Microsoft Power BI Community


    Let me know as soon as possible if the help provided is effective, looking forward to your reply.


    Best Regards,
    Henry


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