Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 8/tkIeXhZYseyjWwF9iZw1
Power Apps - Microsoft Dataverse
Unanswered

Display values not showing in Power BI

Like (0) ShareShare
ReportReport
Posted on 28 Aug 2023 14:25:59 by 6

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:
  • tsaunders7 Profile Picture
    6 on 11 Sep 2023 at 19:36:46
    Re: Display values not showing in Power BI

    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! 

  • MarioRing Profile Picture
    541 Super User 2024 Season 1 on 30 Aug 2023 at 18:23:23
    Re: Display values not showing in Power BI

    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:

    MarioRing_0-1693419583593.png

     

    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.
  • calerof Profile Picture
    255 on 30 Aug 2023 at 16:10:28
    Re: Display values not showing in Power BI

    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

     

  • tsaunders7 Profile Picture
    6 on 30 Aug 2023 at 14:03:10
    Re: Display values not showing in Power BI

    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!

     

     

     

     

    tsaunders7_0-1693404068402.png

     

  • calerof Profile Picture
    255 on 28 Aug 2023 at 20:23:29
    Re: Display values not showing in Power BI

    Hi @tsaunders7,

    Could you post a screen shut of what you are seeing?

    F

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
SadFox Profile Picture

SadFox 2

Overall leaderboard

Featured topics