Forum Discussion
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 backu...
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.