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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors