cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RJH Frequent Visitor
Frequent Visitor

Pulling Data from Custom Properties in the SharePoint Term Store to Power BI

Hi everyone,

 

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.  

 

Term Store Custom Properties.png

 

 

 

 

 

 

 

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?

 

Thanks!

 

Richard

2 REPLIES 2
Community Support Team
Community Support Team

Re: Pulling Data from Custom Properties in the SharePoint Term Store to Power BI

Hi RJH,

You siad you add this in List, could you get this from sharepoint? I am not familiar with this part and will ask other engineer to help me test this in my environment, I will inform you as soon as I get it. You could refer to Using Power BI to Report on Managed Metadata Fields in SharePoint for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RJH Frequent Visitor
Frequent Visitor

Re: Pulling Data from Custom Properties in the SharePoint Term Store to Power BI

Hi Zoe,

 

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!

 

Richard

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,350)