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
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!
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:
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
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!