Forum Discussion

YonghunLee's avatar
YonghunLee
Icon for Helper I rankHelper 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

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    YonghunLee This question is more for SQL Server community forum instead of Power BI forums.

     

    ✨ Follow us on LinkedIn

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    4 years ago

    If it's an on prem SSAS then I'd create a SSIS project to do this in visual studio, deploy it to your SQL server and automate it with SQL Server Agent.

     

    In SSIS there are built in tasks for processing SSAS.

     

    You can then make a connection to SSAS and run a basic query (If Tabular then EVALUATE TableName) and pipe it to a SQL table.

    Currently I can't make SSIS work with an XLMA end point from Power Bi though.

     

    If you need more direction drop me a message!