SharePoint List using SharePoint Connector: View of Managed Metadata / Term Store Values

[Daniel Frins]

SharePoint List using SharePoint Connector: View of Managed Metadata / Term Store Values

 

Hi all,

 

'm loading data from a SharePoint (Office 365) list using the SharePoint connector. I get all of my data just fine, but some of the list columns have values stored as Managed Metadata (Term Store).

The data loaded from the list is shown as the full object, eg.:

System.Collections.Generic.Dictionary`2[system.String,System.Object]

 

I am familiar on how to work with these field types in PowerBI, but cannot seem to find the correct setting to get this setup in SpotFire, so the column shows the term value, not the object.

Thanks in advance all,