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. 

[bcdobbs]

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!

[parry2k]

@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.⚡