Forum Discussion

BrianD's avatar
BrianD
Regular Visitor
2 years ago
Solved

Unable to export to csv file

Hi,

 

We are currently unable to export a .csv file from power bi desktop. We are getting error message to state that we are unable to export as the file is to big despite in some cases there only being 300 or 400 rows. This is even the case for files we have just last week been able to export. Are others experiencing this issue today?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BrianD ,

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

20 Replies

  • foodd's avatar
    foodd
    Community Champion
    2 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.

    • BrianD's avatar
      BrianD
      Regular Visitor
      2 years ago

      Hi,

       

      Is there a timeline for resolving this issue as we have a number of reports which have significant number of lines which we would require to be able to export to excel and currently we are unable to do so.

       

      Thanks for flagging that this is a known issue.

      • Sukhraj_Ghuman's avatar
        Sukhraj_Ghuman
        Regular Visitor
        2 years ago

        I just found another workaround.

        You can upload the report online and you can export the data from P.Bi online, with this method io could download all the rows.


        Thanks

         

    • Sukhraj_Ghuman's avatar
      Sukhraj_Ghuman
      Regular Visitor
      2 years ago

      I  tried to export with dax studio, but it trunc for 500 rows, its better but still dont enought.


  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi BrianD ,

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards
    Community Support Team _ Rongtie

    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
    Community Champion
    2 years ago

    A handy alternative or primary resource to export to CSV would be 

    DAX Studio.

     

    The current reference to DAX Studio is:  DAX Studio | DAX Studio

     

    When exporting, choose CSV or Static Excel File as shown in the screenshot below:

     

     

     

  • Sukhraj_Ghuman's avatar
    Sukhraj_Ghuman
    Regular Visitor
    2 years ago

    Hi,

     

    im having the same exact problem since yesterday, i tried with the method above (DAX Studio) but i can only export the table data (not visual) in P.Bi.

    I want export from visuals! 

    Thanks

    • foodd's avatar
      foodd
      Community Champion
      2 years ago

      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.

      • Sukhraj_Ghuman's avatar
        Sukhraj_Ghuman
        Regular Visitor
        2 years ago

        Hi, thanks for the response and it's working but i cant extract all the rows in the table but the only thats visble in the table, why's that? 

        I tried to extract 4577 rows but only 500 is extracted in the CSV file.

         

         

        Thanks for the quick response!!

         

  • BrianD's avatar
    BrianD
    Regular Visitor
    2 years ago

    Hi,

     

    Thanks for the responses, we won't be adding dax studio. Is this a push towards power bi pro, we have never had this issue previously?

     

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi BrianD ,

    The issue has been resolved now, please have a try.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • BrianD's avatar
      BrianD
      Regular Visitor
      2 years ago

      Hi,

       

      I just tried refreshing a Power BI report with a significant number of lines and still got the same error message that data too large, some data sampling may occur

      • foodd's avatar
        foodd
        Community Champion
        2 years ago

        It appears to be fixed on the version of Power BI Desktop from the Microsoft Store.  Successfully exported 2134 rows as CSV.   Screenshots below: