Forum Discussion

DrummingAddict's avatar
DrummingAddict
Frequent Visitor
2 years ago

9K rows export causing the Data Limit error

Users are trying to export visuals with between 6K and 9K rows to csv and they receive the dreaded "Data exceed the limit" error message.  The issue began today, previously users could export without...
Need Help
CaptainCowell's avatar
CaptainCowell
Advocate I
2 years ago

I am experiencing the same issue. It started 24 hours ago. Trying to export data to CSV from visuals with 1K to 9K rows, which had always worked before, now throws the message: 

Data exceeds the limit

Your data is too large. Some data sampling may occur.

I have a Power BI Pro license. Interestingly I have noticed that in my case at least, the CSV files now being exported from any visual are consistently limited to 300 rows, whereas the limit in the Power BI Service is documented to be 30,000 rows for CSVs.

I have tried applying all latest updates to my computers, tried on different computers and in different browsers, but always consistently the same outcome.

As a workaround, which I appreciate will not be possible for everyone, I resorted to working with the report in Power BI Desktop, rather than the Power BI Service, where I was able to refresh the data and export the visuals to CSV from there, which gave me all the rows I was expecting.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi 

    I have PowerBI desktop and I have the same issue. It started the 14th of September 2023. The data that I'd like to export are the same of one month ago when I was able to export 30000 rows. I cannot choose to export in xlsx format only csv