Forum Discussion

danielbranda0's avatar
danielbranda0
New Member
9 months ago
Solved

Power BI Desktop “Web: Request Failed” when refreshing SharePoint Excel queries (_api/contextinfo)

Summary: Power BI Desktop suddenly stopped refreshing SharePoint Excel queries on one specific computer, even though everything works perfectly on another machine using the same account and Power BI...
Need Help
Tutorial Requests
  • xifeng_L's avatar
    xifeng_L
    9 months ago

    Hi danielbranda0 

     

    This may be a problem with the network or API version. You can try adding the API version to the connection function in SharePoint, for example:

     

    SharePoint.Contents(SharePointSiteUrl,[ApiVersion="Auto"]) // Can try auto mode, if not useful pls use below version.

SharePoint.Contents(SharePointSiteUrl,[ApiVersion="14"])  // English Site

SharePoint.Contents(SharePointSiteUrl,[ApiVersion="15"])  // Not English Site

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
8 months ago

Hello I had the same problem for two months and in the support of microsoft they did not know how to give me an answer, after they changed the equipment in the company I did not connect sharepoint, however I was reviewing and testing some things, at the end of everything among many tests measuring the ping of the Sharepoint site I observed a very high latency, I disabled the IPv6 protocol, I disconnected the network, I reconnected and it worked, I don't know what the origin of the failure is, if it has to do with an update or something, I discard my network because I have good speed and I tried other networks, at the moment it continues to work after disabling the protocol, test if it works for you, it can be of help.