Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a list from sharepoint that is imported to power bi, one of the columns in the sharepoint has multiple options however the same column is not showing the values in power bi but shows List value instead. I tried to expand the list, unfurtunately, instead of getting the values of the list, i get numbers (id). Do you know how to fix it? I need the values of the list to be shown in the column in power bi.
Thank you in advance
Hi @Soldado,
It sounds like the column with multiple options in SharePoint is a "Choice" column, and Power BI is displaying the internal values instead of the labels. To fix this, you need to tell Power BI to use the labels instead of the values.
Here are the steps to do that:
If this doesn't work, you can also try changing the column type in SharePoint to a "Single line of text" column, and then re-importing the data into Power BI.
Let me know if this solves your issue!
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.