Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |