Forum Discussion
Displaying SharePoint 2010 multi-value choice columns in one query column
In my work environment SharePoint 2010 is still very much alive and I run several Power Query scenarios with SharePoint 2010 data. Yesterday, I worked on a query that includes a multi-value choice c...
Have a look at the FieldValuesAsText column. I blather on about this approach here: http://whitepages.unlimitedviz.com/2016/07/simplified-method-working-sharepoint-data-power-bi/
Hi John,
I saw that blog post, but I could not apply it. I don't see that column, neither in Power BI nor in Power Query. I'm accessing SharePoint 2010 on prem, maybe that is why it's different to SP online.