RLS access update solution

[Anonymous]

Hi guys, I built a table imported from excel in order to use botton in PowerBI to select restricted pages and to make role level security controls, and there to be situations with users replaced, quit or join in the workspace to use the report, is there to be any good way for me to contron the update, may be update the excel file and connected gatway to refresh, do you have any good ideas? Thank you.

[Burningsuit · Accepted solution]

Hi @Anonymous 

Take a look a Power Apps and Power Automate.

With Power Apps you can generate a user-friendly App that allows them to change the data held in the Excel Spreadsheet.

With Power Automate you can create a "flow" that says something like "When the data in the spreadsheet changes, then fire a Refresh on this Dataset".

Both Power Apps and Power Automate are Microsoft applications, licenced separatly from Power BI, but tightly integrated with it.

see: Using Power Apps, Power BI and Power Automate Together -

Hope this helps

Stuart

[Anonymous]

If in a dataset contains different sources, one is from database connected with ODBC, another is from Excel files, I want to make adjustment in Excel data and refreshed to Power BI, do the Apps soulution support this multiple data sources?