cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
null
Helper V
Helper V

RLS access update solution

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.

1 ACCEPTED SOLUTION
Burningsuit
Super User
Super User

Hi @null 

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

View solution in original post

2 REPLIES 2
Burningsuit
Super User
Super User

Hi @null 

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

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?

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors
Top Kudoed Authors