Forum Discussion

Bhav_Par's avatar
Bhav_Par
New Member
3 years ago
Solved

Data Exceeds the Limit

Hello Guys,   For the last couple of days, i am having issues exporting the data to Excel even though the rows are less than 30K.   I have never had this issue before and now any report i try to ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Bhav_Par ,

    This issue had been fixed, please try again.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

This is a known issue.

 

Issue ID:  498

Title:  Export to CSV file truncated at 300 rows

Description: When you select Export data on a tabular visual's options menu and choose to export to a CSV file, the resulting downloaded file is truncated to 300 rows, rather than showing all the available rows.

Status:  Active

Reference URL:  https://learn.microsoft.com/en-us/power-bi/troubleshoot/known-issues/known-issue-498-export-csv-file...

 

Additional workaround:  Use DAX Studio to export data from selected Visual to CSV or Excel.

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
3 years ago

First step:  Install DAX Studio and it will be added as an external tool

Next Step:  Follow the instructions below to connect the model and  export 

data to CSV or Excel using DAX expression from specific visual

 

 

Using Performance analyzer you are able to capture the DAX query behind the visual.  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.