Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Resident Rockstar
Resident Rockstar

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

View solution in original post

2 REPLIES 2
Burningsuit
Resident Rockstar
Resident Rockstar

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
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors