Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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, qui...
Need Help
Show and Tell
  • Burningsuit's avatar
    Burningsuit
    4 years ago

    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

Burningsuit's avatar
Burningsuit
Resident Rockstar
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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?