DAX Tools - DAX Studio 15 - Export data

[@joaocscorp]

Is it possible to export the measures results too? (like a calculated column)

[@Bharath_PBI]

Thank you 👍 As I've used CSV export, not to database. I believe it would ask for append or overwrite action if the table already exists, just like in SQL import export wizard feature..

[@NoShadowOfDoubt1]

A good option for data migration and simple , thank you

[@ManishSingh-ds3qn]

Thanks for sharing. I have one question, What if publish this report and need to transfer data from power bi to SQL automatically on a regular basis? Please suggest, thank you

[@golodiassaid4879]

Awesome as usual, thank you!

[@scbleecker]

Great video! Thanks for creating this Dax studio series! Curious if there is a way to use the export to sql option to append the export to an existing sql table? I have been experimenting with it but it seems like it just overwrites the existing data in the sql table instead of adding new records.

[@SQLBI]

Not yet, it could be an idea for a new feature. You should post similar questions in the GitHub discussion area of DAX Studio: github.com/DaxStudio/DaxStudio/discussions

[@scbleecker]

@@SQLBI Thanks for the reply Alberto!

[@dgosbell]

@@scbleecker turning off the "truncate tables" tick box in the first page of the SQL wizard is meant to just append the data onto any existing data in the table but it has a bug in it. I've raised an issue to track this here github.com/DaxStudio/DaxStudio/issues/520 . I can see where the issue is occurring and it should not be too hard to fix

[@moemoekhine2513]

Can we export with schedule ?

[@SQLBI]

Not yet - read this: github.com/DaxStudio/DaxStudio/issues/92

[@hamedelbhrawy7292]

dax studio error exporting data to SQL Server Table: The given ColumnMapping does not match up with any column in the source or destination. How to solve ?

[@SQLBI]

Post DAX Studio issues here: github.com/daxstudio/daxstudio/issues

[@น้ําพริกปลาทู-ญ5ผ]

How about oracle?

[@FellTheSky]

but whats the dax command to export to a file?. Im doing a script and i need to know how to export it directly to a file. Because Evaluate brings a pop up and it needs to be manually set.

[@SQLBI]

There is no DAX command to export, you have to use the DAX Studio feature to do that. It is not scriptable at the moment.

[@__HumanBeing]

I hope this tool help me with Datawarehousing. I have not been able to find another way of easily exporting data from Power Bi.

[@SQLBI]

You can also use bravo.bi now

[@florentibus01]

Nice! This is still a static data dump in SSMS correct? The tables won’t get updated in SSMS if ever the Power BI tables change?

[@SQLBI]

We don't understand your question. Please, can you clarify?

[@florentibus01]

@@SQLBI After I do an export to SQL tables, if ever in the future I have a new product or new customer in my Power BI model, it won't refresh my tables in SSMS I believe. I'd have to drop the tables and do another export. The connection is established just for the time of the export rather than a live connection if that makes sense?

[@SQLBI]

Yes the export is always for the entire table.

[@apamwamba]

I usually export to csv (super!) and the exporting to SQL SERVER. Expoering to SQL SERVER directly creates tables but messes up the data types. How i wish it could detect the available data types and stick to them. Otherwise i am forced to overwrite the existing tabels and run a script in SQL SERVER to recreate the data types... takes 5 minutes ona 3million records table..not bad for a great tool.. Thanks.. JM

[@mohitmanwani5298]

Amazing!!

[@laviedandre]

Anyone face issues with the Output option on the Navigation Ribbon not actually providing the Results of the query? I'm not trying to 'Export Data' just get a copy of the query results.

[@laviedandre]

Solved! You have to first highlight the actual text of the query then it'll provide the Output. Because, sure.

[@elmiguel1022]

Is there any way to export data programmatically? to have a job that export the data daily?