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

[Anonymous]

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 running into error when I click on Table.

Dont know why this specific column is showing red.

[MCY]

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 😉

[v-angzheng-msft]

Hi, @Anonymous 
Thank you for sharing😀. Could you please mark your post as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

[Anonymous · Accepted solution]

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.