Power BI Get Data from Dataverse Column with value from Choice not what i expected

(0) Share

Report

Posted on by komengem

I have a custom table in Dataverse. One of the columns selects a value from a Choice i created. When i connect Power BI to the custom table, the column that gets a value from a Choice does not display the expected value, instead it displays what i assume is the key to the values i have in my Choice. I can also confirm that Power Apps displays the expected value when a record is viewed using the app i created. Has anyone seen this problem before, what was your workaround?

Categories:

Tables

Microsoft Dataverse

All responses (1)

Answers (0)

ChrisPiasecki 6,389 Most Valuable Professional on at

Like (0)

Report

Re: Power BI Get Data from Dataverse Column with value from Choice not what i expected

Hi @komengem,

Below is a, walkthrough on how to get the choice (option set) labels in your Power BI report.

https://markcarrington.dev/2021/03/09/optionset-labels-in-power-bi-reports/

The other option (the article also mentions) is to use the PowerBI OptionSet Assistant plugin for the XrmToolbox.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.