Scheduling Dashboard with Power Automate

Hi. No Power Automate is not mandatory because it's only using the Power Bi Rest API, so you can use that writting, for example, a python code. You need a dedicated capacity in order to export to file with the API.

I really don't know how to handle it with Power Automate, I can show you the doc for the specific endpoint for doing this. It's this one: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group

Building this request for using RLS can be very very tricky. So be careful when writing the code. Make sure you test it a lot.

Just in case consider reading the limitations before doing it: https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to#considerations-and-limitations

I hope that helps,