Unanswered

Display values not showing in Power BI

(0) Share

Report

Posted on by tsaunders7

I am new to Power Apps and Power BI. Our organization created a Power Apps project. I am building a Power BI dashboard and connecting the data with Dataverse. Most fields come through fine when imported to Power BI but the fields with "choices/lookup" are showing as these long html like results (04e1cfda-b728-ee11.......), not the display name or value as showing in the power apps table itself.

I did not build the project but am tasked to figure out the solution. Any direction would be helpful. We really want to know if this is a limitation with power apps to power BI or if we need to troubleshoot our build.

Thank you!

-T

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

calerof 255 on at

Like (0)

Report

Hi @tsaunders7,
Could you post a screen shut of what you are seeing?
F

Was this reply helpful? Yes No
tsaunders7 6 on at

Like (0)

Report

In the tables in power apps this list shows names but when I try to make a visualization in power BI it shows this. Is there anything I can change so it shows the names rather than the values?

Any help is much appreciated!

Was this reply helpful? Yes No
calerof 255 on at

Like (0)

Report

Yes, it would be useful if you share some data, screenshots of your model, how you are choosing columns from Dataverse, etc., in order to be able to help you.
F

Was this reply helpful? Yes No
MarioRing 541 Super User 2024 Season 1 on at

Like (0)

Report
Hi,
You've chosen the wrong field from the list of available fields. Lookup fields usually come here with two variants - one contains the unique GUID (primary key), and the other one contains the actual name of the related record.

For instance, if you create the visualization for the Account table, there are two fields available (among others):
"Primary Contact" and "primarycontactid".

See the picture:

If this doesn't work:
Make sure you've selected all the tables you want to use in your visualization. If your data model contains lookups, use all the tables involved you want to see in the Power BI report.
Make sure that all required relationships in your data model are properly set. The Power BI should do this automatically.
Use foreign fields on your visualization. For instance use "Full Name" from the Contact table instead of "Primary Contact" from the Account table.

Was this reply helpful? Yes No
tsaunders7 6 on at

Like (1)

Report

Thank you for the reply,

I am still stuck, and I am learning so it's hard to articulate the problem sometimes. I understand what you are saying about the two variants, and I have tried all combinations. I have all the right tables in my power BI and I understand how to connect the data. Essentially once I get it into Power BI my choice columns work fine but my choices columns don't. As far as I know, my IT guy that built this thing used "choices" for some of our drop downs and I cannot get the visualizations to work. They will however pull the value that is associated with the text of dropdowns. I can't seem to find a great answer, so I am wondering if this is a limitation of some kind.

Thanks!

Was this reply helpful? Yes No