Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sharepoint online list column throwing (500) Internal Server Error. (Specified method is not support

hi everyone   I have sharepoint online list imported successfully to PowerBI desktop. When I am trying to expand below highlighted SecurityResource_test column, there are no columns to display and...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I ended up resolving the issue by joning Security ID column with user reference table.

    The SecurityResource_test column  shown above was not configured properly and is actually deprecated.

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 😉