Power BI + Dataverse as db

[Anonymous]

Hello all!

I have some troubles with my data stored in my dataverse database. I just builded a APP in Power Apps using Dataverse as a db, and then i connect that data to Power Bi, but have the first problem.

I set a choices for a column like that (In Dataverse Options):

As you can see, i put a "label" and the Dataverse in automatic created a "value" for each lebel. Then, when i connect that data to Power Bi i just see the VALUE, and can't have access to the LABEL.

Here's a pic:

For the column "cr248_area" i just see the VALUE instead of the LABEL. But in Dataverse, i can't set the VALUE as a text, only admits numbers.

So, i can't see the "real data" of my app because datavese through power bi only show me the numeric value and not the label.

Some of you have the same problem?

Thanks a lot, cheers

Lucas

[v-shex-msft]

HI @Anonymous,

So you mean these custom fields are added on the power apps side instead of the database and you failed to get these custom fields' names?

If that is the case, I think the issue should be more related to power bi getting the custom fields from powerapps designs. You can try to directly add these fields to your original database to confirm if they appeared on the power bi side.

Regards,

Xiaoxin Sheng