Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerBI reading column with multiple values as Table

I'm trying to create a dashboard from a SharePoint list. The list contains few columns with multiple names. The problem is when I try to read the same in PowerBI, these columns are being read as tabl...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    I was able to figure this out.

    There is a column which is retreived along with other columns during this process named "FieldValuesAsText". Using this column, we can convert more than one column with data as lists, tables etc and extract the data values at the same time.
    This worked flawlessly and it retreived the data in shorter time as well.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I was able to figure this out.

There is a column which is retreived along with other columns during this process named "FieldValuesAsText". Using this column, we can convert more than one column with data as lists, tables etc and extract the data values at the same time.
This worked flawlessly and it retreived the data in shorter time as well.

hsripathi's avatar
hsripathi
Frequent Visitor
5 years ago

This solution looks very simple and effective. Which lead me to another question - Why did PowerBI confuse us by simply not showing us only this columns. Afterall, most of the users who use SharePoint as the data-source would first want to see the direct columns from the SharePoint list. What might be the reason PowerBI did what it did?