I have a SharePoint site with data stored in Term Sets in the Term Store linked to Managed Metadata fields in lists. I'm using functionality in the Custom Properties tab to store some additional data about Terms.
I'm able to pull Term Store data across to Power BI - it's found in the TaxonomyHiddenList when I connect to my SharePoint Online site - but I can't find this Custom Properties data anywhere.
Does anyone know how I can make this data available in Power BI?
Not sure what you mean by 'can you get it from SharePoint'? I have Term Set data referenced in SharePoint lists by way of Managed Metadata fields, but this Custom Properties data is actually still not available to be viewed in SharePoint lists. I think it's a bit of functionality that could probably use some improvement from Microsoft. When I pull List data from SharePoint using PowerBI, this Custom Properties data is not available there either - perhaps that's what you mean.
Thanks for the link. I had seen that post previously - I even posted this same question in the comments of that blog! It was very helpful, and I actually used that as a guide in pulling Term Store data to SharePoint, but in following those steps I still was not able to see any data from the Custom Properties tab of the Term Store in Power BI.
Look forward to hearing the results of your testing!