Forum Discussion

dibeau's avatar
dibeau
Frequent Visitor
1 month ago

Power App visual in Power BI

Hi guys   I'm trying to get a Power App visual to work inside of a report. The idea is that an enduser can add information to the report.   The issue is that in the report, when a row is selected...
Need Help
AnkitKukreja's avatar
AnkitKukreja
Super User
1 month ago

Hi! dibeau 

 

The issue is that in the report, when a row is selected, the data only shows in the Power App visual when there is already data in the dataverse columns (Ogenummer, Controle, Opmerking).

 

I think it has something to do with the uniqueness of the data in Ogenummer and eenheidid (wich are related through a 1:1 relation). I'm not exactly sure what is going on. I would appreciate it a lot if someone could help.

 

 

 I think this is expected. When you've the data in Dataverse then only it will display the data else not. Not sure if this is your ask? Please provide more clarity if you have different question.

 

 

 

  • dibeau's avatar
    dibeau
    Frequent Visitor
    1 month ago

    Hi Ankit

     

    Thanks for the reply. I'm trying to figure out why that should be expected. In the youtube instructions it looks like you should also be able to select rows that don't have any data in the dataverse columns. The problem is that the PowerBIIntegration does not register a value in eenheidid to send to the Power App.

     

    In the screenshot below I've tried to make it more clear by only selecting the most essential columns:

     

     And this makes the form completely empty. Instead of fill Ogenummer with eenheidid.

     

    The formula in the defaultmode property of the form in the Power App looks like this:

    If(CountRows(Filter(Notities; Ogenummer = First(PowerBIIntegration.Data).eenheidid)) = 1; FormMode.Edit; FormMode.New)

     

    And the formula in the value property of the Ogenummer field is:

    If(CountRows(Filter(Notities; Ogenummer = First(PowerBIIntegration.Data).eenheidid)) = 1; Parent.Default; First(PowerBIIntegration.Data).eenheidid)

     

    • v-abhinavmu's avatar
      v-abhinavmu
      Community Support
      1 month ago

      Hi dibeau,

      Thanks for reaching out to the Microsoft Fabric Community forum. and thanks to AnkitKukreja   for sharing valuable insights. 

       

      Could you verify that "eenheidid" is still included in the data fields associated with the Power Apps visual? The PowerBIIntegration object acts as a read-only data source and is used to access the data passed from Power BI. Could you verify that the required field is available there?

       

      Also, if the data fields associated with the Power Apps visual were changed after the app was created, try editing the app from within the Power BI Service (ellipsis (...) > Edit) and then republishing the app. Otherwise, the changes won't be propagated to Power Apps, and the app may behave unexpectedly.

       

      Could you also confirm whether the data fields associated with the Power Apps visual were modified after the app was created?

       

      For more information, please refer to the following Microsoft Learn documentation:

      Power Apps visual for Power BI - Power Apps | Microsoft Learn

       

      I hope this helps. Please feel free to reach out if you have any further questions.
      Thank you.

      • dibeau's avatar
        dibeau
        Frequent Visitor
        1 month ago

        Hi v-abhinavmu 


        Thanks for replying. I can confirm that eenheidid is still included in the data fields associated with the Power Apps visual. Because this is the formula of the datacardvalue: 

        If(CountRows(Filter(Notities; Ogenummer = First(PowerBIIntegration.Data).eenheidid)) = 1; Parent.Default; First(PowerBIIntegration.Data).eenheidid)
         
        The issue is that it doesnt show any data when i select a row that has data in the columns "Opmerking", "Controle" and "Ogenummer". These are all dataverse columns. The rows that dont have any data in those columns are only visible when I select "Show items with no data". Maybe thats a lead.

         

        Also the data fields where not modified.