Hello,I've created a complex query from 7 different sources. (excel files, database connections, folder with csv files)This query contains a lot of appends, merges, and transformations on all the sources.The final results I wanted and I have is a table containing approximately 90 000 rows and 25 columns.I would like to share this data table with others without creating a visual dashboard or a pivot table (too much data to perform a pivot table on my computer).How can I simply export in excel the results of my query ?Thanks a lot for your responsesBest regards,Christophe

Hello, If you want to copy the table to an excel, why not trying to apply the filters that you want in the query editor, and then on the data view, copy the table? I've tried copy pasting a table with 116k rows and 58 columns, works.

How to export some huge query results in excel

14 Replies

idategto11
Frequent Visitor
9 years ago
Hello,

I've created a complex query from 7 different sources. (excel files, database connections, folder with csv files)
This query contains a lot of appends, merges, and transformations on all the sources.

The final results I wanted and I have is a table containing approximately 90 000 rows and 25 columns.

I would like to share this data table with others without creating a visual dashboard or a pivot table (too much data to perform a pivot table on my computer).

How can I simply export in excel the results of my query ?

Thanks a lot for your responses

Best regards,

Christophe
- MattAllington
  Community Champion
  9 years ago
  Yes you can do this.
  
  From powerbi.com, read my article here. https://exceleratorbi.com.au/extract-tabular-data-power-bi-service-excel/
  
  If you want to do it from the desktop, use the same approach and combine it with what you learn at my other article here https://exceleratorbi.com.au/excel-workbook-connection-local-power-bi-desktop/
  - masplin
    Power Participant
    9 years ago
    Ah I've been looking for an answer to this all over!!!
    
    If you use analyze in Excel are you just getting a snap shot so you would have to repeat the process to get fresh data?
    
    I really need a solution that is like the old dax query table in a powerpivot model, but cant find anything.
    
    Thnaks
    Mike
- masplin
  Power Participant
  9 years ago
  Sadl;y there seems no tool to do this in power BI. Are you working form Power Bi Desktop or in Powerpivot?
  
  If you are in powerpivot or using DAX Studio you can use a statement like this to draw a table even querying across related tables. TYuo can add filter conditions and order conditions.
  
  evaluate calculatetable( summarize( vehicles, vehicles[VRM],customer[mobile phone no],customer[e-mail],vehicles[mot due date],vehicles[make],vehicles[model],vehicles[date of 1st registration],customer[last centre],vehicles[next service date], vehicles[last visit date], vehicles[service due],vehicles[customer 1y active], customer[full name], customer[address],customer[address 2],customer[city],customer[post code],customer[customer group],customer[Plat MOT Avail], customer[Plat XS Avail],customer [MOT reminder platinum], customer[XS reminder platinum],customer[salutation],customer[first name],customer[surname] ), FILTER( vehicles, vehicles[mot rem output]="yes" ) )
  ORDER BY vehicles[MOT Due Date], vehicles[VRM]
  
  I have not used this in DAX Studio but beleieve it works if you link up Dax studio to your Power BI model.
  
  If oyu have a single table I think you can just slect the whole thing in table view in Desktop and cut and pate to excel. Hopefully this link covers all options
  
  exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/
  
  Mike
dkay84_PowerBI
Microsoft Employee
9 years ago
Maybe someone else mentioned this as I didn't read through every post, but while you can easily "copy table" and paste into excel, perhaps consider using an R script as the last step in your query to write the table to CSV if you want to do this on a regular basis.