Forum Discussion
DAX Studio exporting to SQL Server: can I get this export to run every time PBI report is refreshed?
Hello,
I just found out that we can export a PBI query output to SQL Server.
Is there a way I can automate this export so that I don't have to open the report every month and export manually from DAX Studio?
Ideally I would like this export to run every time the PBI report is refreshed as per schedule.
Thanks in advance for any insight.
Hi aparadis1993 ,
You can use Power Automate to create a custom workflow that triggers when the Power BI report is refreshed.
Please refer to the following document for more information.
Exporting Power BI Data to SQL Server (biinsight.com)
Export and email a report with Power Automate - Power BI | Microsoft Learn
Exporting Data From Power BI to SQL Server Using Python | Sandeep Pawar (pawarbi.github.io)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi aparadis1993 ,
You can use Power Automate to create a custom workflow that triggers when the Power BI report is refreshed.
Please refer to the following document for more information.
Exporting Power BI Data to SQL Server (biinsight.com)
Export and email a report with Power Automate - Power BI | Microsoft Learn
Exporting Data From Power BI to SQL Server Using Python | Sandeep Pawar (pawarbi.github.io)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.