Forum Discussion

Soldado's avatar
Soldado
Frequent Visitor
3 years ago

Query does not display values from sharepoint list

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 sho...
Need Help
ichavarria's avatar
ichavarria
Solution Specialist
3 years ago

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:

 

  1. In the Power BI desktop, select the table that contains the column with the Choice field.
  2. In the Fields pane, find the column with the Choice field and click on the small down arrow next to it.
  3. Select "Change Type" -> "Using Locale"
  4. In the "Using Locale" dialog box, select the language that corresponds to the language of your SharePoint site, and then click "OK".
  5. Power BI will refresh the data and should now display the labels instead of the internal values.

 

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