Export only extracts 300 rows on Summarized Data, File Format .csv

[TWolsten]

Hi there,

I have a noticed a recent issue where people are trying to use the export via the Summarized Data and the File Format .csv 

It says it has a limit of 30,000 rows but on any export it only retrieves the first 300?

Can this be investigated please?

[foodd]

@Cyrilbrd,  DAX Studio readily connects to the local model and allows the export of any or all tables, as well as summarized data contained within a Visual.   There are no export ceilings, and returns are very fast, and easy.

USING DAX STUDIO TO EXPORT FROM VISUAL:  DAX Studio when installed will appear as an External Tool in Power BI Desktop.  One of it's many features allows the export of data from selected Visual to CSV or Excel (leverage created DAX to export).

In Power BI Desktop using Performance analyzer you are able to capture and reveal the DAX query behind any Visual on a Report.  Then, copy the DAX query, and use this in DAX Studio to return the data behind the visual.  This is also quite handy when writing documentation.

In this case, the DAX expression would be :

// DAX Query used by Table Visual to return Gross Sales column data
DEFINE
    VAR __DS0Core =
        DISTINCT ( 'financials'[Gross Sales] )
    VAR __DS0PrimaryWindowed =
        TOPN ( 501, __DS0Core, 'financials'[Gross Sales], 1 )

EVALUATE
__DS0PrimaryWindowed
ORDER BY 'financials'[Gross Sales]

Follow Gilbert Quevauvilliers post from June 2022 for general instructions.

[Cyrilbrd]

@foodd noted with thanks.

[Anonymous]

I don't feel I can get all the data from the server, anyone tested it?

Hope they can fix it soon.

P.S. I don't have Dax Studio in the office

[foodd]

@Anonymous,  from what I have read of the posts from one or more MSFT Community Moderators a fix may or may not be rolling out to the Service and or Power BI Desktop.

Understand you mentioned DAX Studio is not available in the office.    Perhaps you are not aware that DAX Studio is available as a portable version, and does not require elevated permissions to install.  You could even store it on a thumb drive if you wished.  It is quick and easy to use. 

Even when Issue #498 is resolved, Power BI Service and Desktop will impose limits on exporting data stored in the model.  This is not the case with DAX Studio and one of the reasons it is endorsed by Microsoft as a development and auditing tool.

https://daxstudio.org/

[Anonymous]

@foodd 

Thanks for the help, I did not actually know about the portable version.

I got only a limited number of rows in the Query in DAX Studio, any hint on that?

[tlanza89_RWL]

@Anonymous Once you paste it into DAX Studio, you might have to adjust the TOPN number from the query. It defaults (for me anyways) to the top 502. You can adjust this as needed.

[foodd]

Thank you @tlanza89_RWL, and yes @Anonymous , that is a good point.  When dumping the table using

Preview Data, for economy, returns the TOP 502 rows.  If you intend to dump the entire table, rather than the Preview table, use EVALUATE 'tablename'.  That will dump the entire table.   Also, you can use Advanced > ExportData to dump one or more tables as CSV from the Power BI model.

[Anonymous]

@foodd @tlanza89_RWL 

Thanks! That worked.

[sgallo]

Same issue here.

The only workaround that I have is to publish the report and then export the data form the browser.

This is obviously not ideal in the long run.

Finger crossed for a quick fix in the next hours/days

[foodd]

@sgallo, following the inspiration and examples in these threads and elsewhere, you are not at a loss

when using DAX Studio to export data from a local file.  This is also a way to backup the data from the local model, in a way that you are not able to in PowerBI Desktop.   Feel free to ask for assistance when needed.   Very fast and easy to use.