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

Many thanks to you, saving my sleep. It was really tough figuring out on my own. Thanks for posting your suggestion.