Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
3 | |
3 | |
2 | |
2 |