Forum Discussion
Cannot convert a value of type Table to type List - data export from a sharepoint
Hello, I'm wondering if anyone could help with this error message I receive in power query when exporting data from a table in sharepoint to Power BI: Expression.Error: We cannot convert a value...
I've exactly the same problem and still not found a solution, do you ?
Hi Neo_Mando, I hope you found the solution to the problem.
My solution was to change UserMultiTransform script. Changes marked in bold below. I hope this helps.
UserMultiTransform = Table.AddColumn(UserMultiTypeRows, "UserMultiTransform", each(name) =>
if (name <> null) then @Text.Combine(Table.Column(Table.FromList(Table.ToRecords(name), Record.FieldValues, UserFieldNames), "title"), ", ") else null, Function.Type)