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

[YonghunLee]

In sql analysis service, i have made a calculated table. 

I want to make data log of the calculated table every day.

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

Can I do it in a sql server management studio?

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. 

[lbendlin]

You can use newer versions of SSMS to run DAX queries against Power BI Datasets.  However that will only get you the results displayed, not loaded into a table.

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.