Forum Discussion

abi21gail's avatar
abi21gail
Frequent Visitor
2 years ago
Solved

Data exceeds the limit

Hi! Few days ago im having issues when it comes to exporting data in the BI. Please suggest any solutions

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi all，

    Update:
    This is a new issue and the Product Group is working to get this fixed.

    Workaround:

    There is an option to roll back the desktop version to mitigate this issue, or use the Export Data on PBI Service to process the data.

    --------------------------------------------------------------------------------------------
    Yes, this is a known issue. 
    The deployment of the fix has begun and has been completed in some areas.
    Please try again and let me know if you have any issues.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Same issue here. Trying to export csv file with 478 rows and i get the error of exceedind limit of 30.000 and the exported file is just 300 rows.

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    This is a known issue and is Tagged as ACTIVE.

     

    Issue ID:  498

    Date:  September 7, 2023

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Same here, but exporting to EXCEL

    • foodd's avatar
      foodd
      Community Champion
      2 years ago

      What is your question? What have you tried and where are you stuck?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        What the user abi21gail shared in the name/description of this thread

        "Data exceed the limit" error when exporting less than the limit 

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi all，

    Update:
    This is a new issue and the Product Group is working to get this fixed.

    Workaround:

    There is an option to roll back the desktop version to mitigate this issue, or use the Export Data on PBI Service to process the data.

    --------------------------------------------------------------------------------------------
    Yes, this is a known issue. 
    The deployment of the fix has begun and has been completed in some areas.
    Please try again and let me know if you have any issues.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum