Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Everyone,
I'm trying to connect a SharePoint List that uses managed Metadata to Power BI. This works fine so far, but when I try to expand the Metadata Columne (which shows [record] first) I cannot extract the Metadata Names (e.g. name of the customer) but only Numbers (looks like IDs).
Anybody know this issue? And might have a solution?
Thanks for your help.
regards
Paul
Solved! Go to Solution.
Are your MetaData Names held in a separate SharePoint List at all? It seems like this is simply a reference ID to the names held in that other list.
If so, you could bring that list in as well and use the table linking to connect them.
Hi @LtKvasir,
Do you use the latest version of Power BI Desktop(2.46.4732.581)? Do you get the same issue in previous version of Power BI Desktop(e.g. April 2017 version)?
Thanks,
Lydia Zhang
Hi Lydia and Ross,
thanks for your replies.
@v-yuezhe-msftI updated to the newest version (2.46.4732.581 64-bit (Mai 2017)) - the problem still persists. I also tried the march version and the problem also exists.
@AnonymousI already expanded the managed metadata column in the screenshot. The SharePoint column-type is "managed metadata" pointing to a term-set.
What I learned from "Google/Bing", the corresponding list should be the "taxonomy hidden list". I'm also experiencing problems there, as the list appers as empty when directly calling it (using managed metadata in SP-lists works fine though). Permissions for "everyone" are correct.
It seems both problems (term labels and empty taxonomy list) are known for a few years. However, I could only find a few posts regarding these issues and they are all 2+ years old. Also none of the solutions there helped for my setting (O365 Business Premium SP)
Thanks,
Paul
After half a day experimenting and web-searching, here's is what I got:
regards
Bug with FieldValuesAsText has been fixes. Working fine now.
Regards