Hey,
To flexibilize user experience, I want to make the possibility for the user to change some data. I have found that PowerApps can do that, it can send data back to the data source and after refreshing the report the changes are live.
I wonder, thought, if there is another option, without refreshing the whole report and make them wait few/several minutes. Today I'm using excel in sharepoint as data source, if I use some SQL database or/and APIs is there another way to get the user to edit data before getting into the report?
Example:
| Role | Group |
| CEO | Administration |
| Financial Analyst | Administration |
| Manager | Administration |
But supposed someone wants to change the CEO role, from Administration to Board of Directors (or whatever else).
| Role | Group |
| CEO | Board of Directors |
| Financial Analyst | Administration |
| Manager | Administration |
The idea is, I do not know how every company defines their roles or groups (in this case) and I don't wanna change every single company everytime. And today, with PowerApps I can change one by one, it would be really good if the user could select a bunch of roles and assign their groups.
Any insights or ideas are welcome. Even if it's outside Power BI, a webpage before the embedded report, API, whatever. What I do not want is for the user to see the data source (would be easier but too fragile), but some fields.
Thanks in advance.
