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~

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
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~