Forum Discussion
Power Ap for updating data source excel file for PowerBI
Hello,
I’m trying to integrate an embedded Power Apps application into Power BI that will allow adding and editing existing entries in the source Excel file used by Power BI. I managed to create the part responsible for adding new records, but editing doesn’t work. Currently, data from the table is not being passed to Power Apps at all when I click on the corresponding row. Another challenge is that I have two access types: Admin, who can add and edit all records, and User, who is assigned to a specific site and should only see records for their site, and be able to edit and add entries for that site. Access control is managed using a table with email, site, and role. How can I solve this problem so that one app can perform both functions?
Hi ZYTOMEEN,
To enable editing, please make sure that all the required fields (including the unique record ID) are added to the Power Apps visual field pane in Power BI. Only the fields added there are passed to Power Apps and made available for the selected row. Once this is done, Power Apps can correctly receive the selected record from Power BI and open it in Edit mode.
For role-based security, you can continue using your existing access table (Email, Site, Role). Based on the user’s role: 1. Admins can view and edit all records.
2. Users can only see records related to their assigned site and are limited to editing/adding records for that site.
This can be controlled directly within Power Apps using filtering and visibility rules, allowing you to maintain a single app that handles both add and edit scenarios.
Thanks,
Prashanth
1. Your Excel table MUST have an identity column and you MUST reference that in your patch statement.
2. Excel is not able to serve as a Direct Query data source so any changes you do there will NOT reflect in the Power BI UI until the next semantic model refresh is completed. This leads to a suboptimal user experience.
4 Replies
v-prasareCommunity Support
Hi ZYTOMEEN,
To enable editing, please make sure that all the required fields (including the unique record ID) are added to the Power Apps visual field pane in Power BI. Only the fields added there are passed to Power Apps and made available for the selected row. Once this is done, Power Apps can correctly receive the selected record from Power BI and open it in Edit mode.
For role-based security, you can continue using your existing access table (Email, Site, Role). Based on the user’s role: 1. Admins can view and edit all records.
2. Users can only see records related to their assigned site and are limited to editing/adding records for that site.
This can be controlled directly within Power Apps using filtering and visibility rules, allowing you to maintain a single app that handles both add and edit scenarios.
Thanks,
Prashanth
- lbendlin
Super User
1. Your Excel table MUST have an identity column and you MUST reference that in your patch statement.
2. Excel is not able to serve as a Direct Query data source so any changes you do there will NOT reflect in the Power BI UI until the next semantic model refresh is completed. This leads to a suboptimal user experience.
- v-prasare
Hi ZYTOMEEN ,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support - v-prasare
Hi ZYTOMEEN,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support