Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
41 | |
30 | |
26 | |
21 | |
17 |