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

 

 

 

Dont know why this specific column is showing red.

 

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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.

  • 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 😉