Forum Discussion

TomD90's avatar
TomD90
New Member
2 years ago
Solved

Expression.Error: We cannot convert a value of type Table to type List.

Hi, relatively beginner when it comes to Power Query and Power BI but trying to learn! I have a script which is trying to pull data from a Sharepoint List into a Power BI Report. The script is: ...
Need Help
  • TomD90's avatar
    TomD90
    2 years ago

    Thanks Pete. Appear to have solved the issue. It was due to the data in People columns being pulled in as nested tables. Have added a couple of steps to expand the nested tables into seperate cokumns and it seems to have done the trick, can now see the data as needed in the report. 
    Thanks again for looking into this one.

BA_Pete's avatar
BA_Pete
Super User
2 years ago

 

Ok. Difficult to say what the issue is here without being able to see what your UserMultiChanges step looks like before this transformation.

 

Are you able to post a small example of your data as it appears at the Source step here please? This will allow me to apply your whole current query to the sample data and see what's going on.

Make sure to remove any sensitive data first, then copy and paste the sample into the Enter Data section in Power Query (max 30,000 CELLS). You can then copy the code from Advanced Editor for that query and paste it into a code window here ( </> button).

 

Pete

TomD90's avatar
TomD90
New Member
2 years ago

Thanks Pete. Appear to have solved the issue. It was due to the data in People columns being pulled in as nested tables. Have added a couple of steps to expand the nested tables into seperate cokumns and it seems to have done the trick, can now see the data as needed in the report. 
Thanks again for looking into this one.