Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

sharepoint list & multivalue field

Hey, 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 ...
Need Help
Tips and Tricks
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous,

 

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

Reference
http://community.powerbi.com/t5/Integrations-with-Files-and/Importing-Multiple-Lines-of-Text-field-from-SharePoint-list/m-p/43868

 

Regards,

Charlie Liao