I want to make sql database and table and sql query to make daily backup of a calculated table.

Question

In sql analysis service, i have made a calculated table.&nbsp;&nbsp;I want to make data log of&nbsp;the calculated table every day.&nbsp;So I want to make sql database and table and sql query to make daily backup of the a calculated table.&nbsp;Can I do it in a sql server management studio?&nbsp;or can I make process in visual studio that first make a refresh to the calculated table and load the data from that, and finally insert the data to the sql database.&nbsp;

lbendlin · Answer

You can use newer versions of SSMS to run DAX queries against Power BI Datasets.&nbsp; However that will only get you the results displayed, not loaded into a table.
&nbsp;
You can use SSIS or the Import/Export wizard to query the Power BI dataset and push the results into a SQL server table. I think.

Forum Discussion

Related content

Fabric Backups

Fabric Cost and Fabric SQL Database backup

Fabric Cost and Fabric SQL Database backup

Lakehouse/Warehouse Backups ?

Power BI backup solution