Hi community,
I am working on an idea at work and I think it can be achieved but wanted advice/guidance before I get into it. I'm putting together a PowerBI report that ingests data from a dataflow. Within the PowerBI report, I want to embed a PowerApp that will allow users to populate data into a SharePoint list that can then be reported back in the PowerBI report.
My questions are:
1 - In the PowerApp, can I link a record coming through PowerBI/Dataflow to a record that will be created in SharePoint within PowerApps itself?
2 - can this link maintain the row level security that is applied in PowerBI?
3 - is PowerApps the best way to achieve this? Or is there another way that is easier?
What I am trying to achieve is a data collection tool that allows managers to record information about the leave balance of their employees. They will get access to their employees leave balance information through a PowerBI report.
The data I collect from the manager then needs to be reported back in the PowerBI report along side the leave balance information.
