Forum Discussion
How to automate daily tasks of executing SQL Store Procedure & save the results to Excel file?
I am new to Power Query and Power BI, I would like to know if there is a way to automate a daily report. My daily task is to send out Excel report with data from 5 SQL Stored Procedures. The curr...
PC2790
Community Champion
Community ChampionHello qjr ,
As per your description of the tasks, it is very much possible to do it in Power BI.
You can connect your Power BI to the SQL from where the data is being fetched and run the scripts within power BI itself.
Then you can work on transforming the data into the desired format, modelling the data and finally visualising the data as per the end users.
The report can be published onto the cloud(Power BI service) and with the proper access given, it can be viewed by the end users anytime of the day.
It calso can be refreshed automatically if the refreshes are setup, without any intervention from your side.