Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error.

Hi, One of my Power BI reports suddenly stopped working and gave me the following error when updating: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. ...
Need Help
MCY's avatar
MCY
Frequent Visitor
2 years ago

Hi Anonymous,

 

I met exactly the same issue for one list whether other lists in the same SP site works perfectly. After two days I've found a workaround by
1) graphical user interface : Get Data -> SharePoint Online list -> select option "Implementation 2.0" before entered your Site URL -> OK.
2) power query : = SharePoint.Tables("YOUR_SITE_URL", [Implementation="2.0", ViewMode="Default"])

Hope it will help 😉

Anonymous's avatar
Anonymous
Not applicable
1 year ago

it worked for me, thanksss !!