Forum Discussion
sharepoint list as table
Hi I have linked a sharepoint online list with powerBI, some of the columns have actual values ie int,text, where as some of the columns have table as values. However on trying to expand and choose a field it says no columns found. And if i try to clock on it it says internal server error. Any advice will be of great help.
Thanks in Advance,
2 Replies
Do you need the data from those columns ? These are lookup columns they are very expensive, and you can expand a maximum of six. Better to not have these. If they are person/group columns then you need to also import the User Information List.
Hi V24 ,
Try adding a step to expand it with m code= Table.ExpandRecordColumn(PrevStepsName, "FieldValuesForEdit", {"Title"}, {"ExpandedColumns"})Table.ExpandRecordColumn - PowerQuery M | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
