Forum Discussion
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.
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