cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Snider Frequent Visitor
Frequent Visitor

Data Exceeds Limit when Exporting

What is actually happening to the data when I am exporting and a warning pop up comes up telling me the data is too large and sampling may occur?

 

Is there a quick and easy way to determine if sampling is actually occuring?  Also, is there an upgrade that will give me access to export more data?

 

2018-01-08_9-11-51.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Data Exceeds Limit when Exporting

Hi @Snider,

 

Please check at below link which told about limitations of export data feature:

Export data from visualizations

Limitations and considerations

  • The maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.
  • The maximum number of rows that can be exported to .xlsx when in the Power BI service is 150,000 for Pro users and 30,000 for Free users.
  • When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.
  • Power BI only supports export in visuals that use basic aggregates. Export is not available for visuals using model or report measures.
  • Custom visuals, and R visuals, are not currently supported.
  • Export data is not available for users outside of your organization who are using a dashboard that has been shared with them.
  • If there is unicode character in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode characters are currency symbols and foreign words. The workaround for this is to import the csv into Excel, instead of opening the csv directly. To do this:

    1. Open Excel
    2. From the Data tab, select Get external data > From text.
  • Power BI admins have the ability to disable the export of data.

Update:
Did you use the previous version of power?
If this is a case, dec version has an issue on export data which has been fixed recently. I'd like to suggest you use newest version and try again.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
AlainATruong Visitor
Visitor

Re: Data Exceeds Limit when Exporting

I'm encountering the same.   I Googled and found that this is a real constraint in PBI, something that Microsoft would probably fix if enough of us complain and make a lot of noise about it.

Community Support Team
Community Support Team

Re: Data Exceeds Limit when Exporting

Hi @Snider,

 

Please check at below link which told about limitations of export data feature:

Export data from visualizations

Limitations and considerations

  • The maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.
  • The maximum number of rows that can be exported to .xlsx when in the Power BI service is 150,000 for Pro users and 30,000 for Free users.
  • When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.
  • Power BI only supports export in visuals that use basic aggregates. Export is not available for visuals using model or report measures.
  • Custom visuals, and R visuals, are not currently supported.
  • Export data is not available for users outside of your organization who are using a dashboard that has been shared with them.
  • If there is unicode character in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode characters are currency symbols and foreign words. The workaround for this is to import the csv into Excel, instead of opening the csv directly. To do this:

    1. Open Excel
    2. From the Data tab, select Get external data > From text.
  • Power BI admins have the ability to disable the export of data.

Update:
Did you use the previous version of power?
If this is a case, dec version has an issue on export data which has been fixed recently. I'd like to suggest you use newest version and try again.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
alex_bdo Frequent Visitor
Frequent Visitor

Re: Data Exceeds Limit when Exporting

Does Microsoft have any plans on extending the export limits beyond 150K records?

 

This limitation is causing many issues for our clients, who would like to continue their analysis outside of Power BI.