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.

TomD90's avatar
TomD90
New Member
2 years ago

Thanks Pete, this is really helpful for my understanding. 

I have now updated the Expanded User Multi step as follows:

ExpandedUserMulti = Table.TransformColumns(UserMultiChanges, { {"Dependency Owner (Accountable)", each null} }, MissingField.UseNull),

From what you said I'm assuming I'm missing an operation in there? (Have just focused on one of the columns for now for sake of simplicity).

I am now getting this error, the opposite of before:

Expression.Error: We cannot convert a value of type List to type Table.
Details:
Value=[List]
Type=[Type]

Thanks again for your help!

BA_Pete's avatar
BA_Pete
Super User
2 years ago

 

Try taking out the ", MissingField.UseNull" argument at the end.

 

Pete