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~

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi danielbranda0 ,


I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

 

Thank you.

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi danielbranda0 ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.