Forum Discussion
Automate power BI processus
I'm working on a Power BI project that: 1/Takes data from Google Sheets 2/Makes some modifications with power Query (or any other program) 3/Create the rapport 4/send it to the client What i want...
the general setup would be:
create a Power BI report with the google sheets as the data source
publish the report to a workspace and/or app (if you are on Premium)
use Power Automate to create a scheduled flow that creates report exports (including report filters for the different clients) and then send the emails.
This is some very heavy lifting for someone new to Power BI and Power Automate. Good luck.