Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate II
Advocate II

sharepoint list & multivalue field


I'm using a sharepoint list for my input. One of the fields is a multivalue field.

When I get this list into a powerbi-file, I can see all the single-value-fields, but for the multivaluefield i don't see the values, only the link list. If i click on this link i get an other display with all the values for this record. I can't split this field, I can't pivot/unpivot it.

How can I get all the individual values in this multivalue field?


The next step would be to change the structure so that this different values are translated to different rows. I think that pivot/unpivot is the solution. I can't try it because i don't see the different values.

Or is there a way to combine this two steps?


In my input, there are different multivalue fields, where i'v the same problemen. If you give me a solution for one multivalue field, can i use this for all the different fields or should this cause a problem.


PS If I export the sharepoint list to excel, I can get the different values. As the sharepoint list is a very dynamic list, i don't like to have the task to export the list every 5 minutes..


Thanks in advance




Microsoft Employee
Microsoft Employee



I have tested it on my local environment, I get the sam result as yours. There are two solution to this issue.

  • Switch the source field in SharePoint to plain text, and in doing so, stopped the additional text from rendering in PowerBI.  This is a quick fix solution that solved my immediate need.
  • Tranfer this column into Power BI by using Power Query, please refer to the link below to see sdjensen's reply




Charlie Liao


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.