Forum Discussion

YonghunLee's avatar
YonghunLee
Helper I
4 years ago

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

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. 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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.