DAX Studio exporting to SQL Server: can I get this export to run every time PBI report is refreshed?

[aparadis1993]

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.

[Anonymous · Accepted solution]

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.