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.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Anonymous 

     

    Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.

  • 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?

  • 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.