Forum Discussion

YonghunLee's avatar
YonghunLee
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.