Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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