Forum Discussion
Power App visual in Power BI
Hi v-abhinavmu
Thanks for the reply. Sorry for the delay. I've published the report to the Power BI Service. We experience the same issue over there.
I'm almost certain that the problem is in the relationship between the tables.
Community SupportHi dibeau,
Thank you for confirming that the same behavior occurs in the Power BI Service.
Based on the Microsoft Learn documentation, the PowerBIIntegration object acts as a read-only data source that contains the data passed from the Power BI visual. The app accesses the selected record through PowerBIIntegration.Data.
Could you verify whether the following expression returns a value for the rows experiencing the issue?
First(PowerBIIntegration.Data).eenheidid
This will help confirm whether eenheidid is available in PowerBIIntegration.Data for the selected row.
For more details, please refer to the below official documentation:
Power Apps visual for Power BI - Power Apps | Microsoft Learn
Thank you.
It does work when the tables don't have a 1:1 relationship and therefor the option "show items with no data" is disabled.
- v-abhinavmu
Hi dibeau,
Thank you for the update.
Based on your observation, the behavior appears to change when Show items with no data is enabled. According to the Microsoft Learn documentation, this feature affects which rows are included in the visual.
The documentation also states that the PowerBIIntegration object acts as a read-only data source in the app. Could you verify whether First(PowerBIIntegration.Data).eenheidid returns a value when Show items with no data is enabled?
This will help determine whether eenheidid is available in PowerBIIntegration.Data for the selected row before the app evaluates your formulas.
For more details, please refer to the below Microsoft official documentation:
- Power Apps visual for Power BI: Power Apps visual for Power BI - Power Apps | Microsoft Learn
- Show items with no data: Show Items with No Data in Power BI - Power BI | Microsoft Learn
I hope this helps. Please feel free to reach out if you have any further questions.
Thank you. - v-abhinavmu
Hi dibeau,
As we haven't heard back from you, we wanted to follow up to see if the suggestion we provided was helpful. If you have any further questions or need additional assistance, please feel free to let us know.
Thank you.