How to quickly export data from Power BI Desktop with DAX Studio

[@msamysobih680]

You solved a big problem for me today, thanks & have a great day :)

[@MitchellPearson]

That's why we do this! Glad it helped :)

[@alexanderchernov6792]

Thanks for the video, Mitchell, it is extremely useful. I just wonder what is the logic behind Export Data to SQL Server table, because when I execute this action multiple times, I'm not getting RowsCount x2, x3 etc, I get only the number of rows that are in my source PBI table. But if I delete few (1-2K) of rows I get (SourceRowCount x2 - DeletedRows) count.

[@wesleyalvin3308]

pro trick: watch movies on flixzone. Been using them for watching loads of movies recently.

[@vancejoaquin2525]

@Wesley Alvin yup, have been watching on Flixzone for since december myself :D

[@karolybakosi523]

Hey Mitchell, First of all thank you for the video. Could you please help me, that is it possible to download a filtered table with DAX Studio which has columns from different tables (connecting to each other with relationship) As an example we have 4 tables in the data model: Sales (FACT table), Customer (DIM), Product(Dim) and Calendar(DIM). And we would like to download a table filtered only for 'Product[ProductID]'=12 and 'Product[ProductID]'=14 in the time period 01.01.2020-01.03.2020. The table should have columns with 'Customer'[CustomerID], 'Calendar'[Date], 'Product'[ProductID] and 'Sales'[Sales Amount]. I can't figure out how should i do it (if it's even possible). :( Thank you for your help and for the amazing videos! Karoly

[@ryanjolliffe]

It is 3 years late, but for anyone else: I found the easiest way was to reference the original dataset, merge as needed to get the final table I want, then export that one with DAX Studio. You can even set this dataset to not refresh with others and refresh manually instead.

[@evelic]

1:43