Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |