Forum Discussion
Unable to access managed metadata/term sets when connecting to on premise SharePoint 2013 folder
dancarr22,
Expand the FiledValuesAsText column after you connecting to SharePoint list or follow the guide in the blog and similar thread below to check termsets information.
Power BI and filtering on Taxonomy/Managed Metadata terms
No Managed Metadata Columns in Power Query SharePoint list queries
Regards,
Lydia
- dancarr229 years ago
Helper V
Hi Lydia,
Thanks for your response.
Unfortunately, neither of these solutions work.
First, we are connecting to a Folder, not a List -- so the 2nd link is not really relevant. Did try it but didn't work.
We also tried the solution prescribed in the first link and it did not work. We are not able to view ANY fields related to term sets when connecting to a SP Folder in Power BI. Several websites describe the process to go through for Lists -- where you see the associated GUID and join back -- but neither the text field nor the guid field is displayed.
Note - we can view this information when connecting via MS Excel and MS Access. We have tried replicated those connection strings -- Excel seems to use OLE - but didn't work.
Thanks,
Dan
- dancarr228 years ago
Helper V
Hello,
Any updates on this? Is this possible or planned for the future?
We may have to not use Power BI if this functionality does not exist.
Thanks,
Dan
- Anonymous5 years agoNot applicable
I understand that this post is now bit old. I have exactly the same issue and now struggling what is the solution for this!! 😞