Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Problem with data export - will not export from vidual more the ~500k in file size

Seems like there is some sort of download limit, around a file size of ~500k. I am trying to export 61 columns of data, with 6800 rows, from a table visual, using the "Data with Current Layout" option, into a xlsx file, from an power BI app on the web.  I can not get all the data in one download.   I only get about 2600 rows when I download, all 61 columns.   I noticed that if I reduce the number of columns, I get more rows.   However, the size of the file seem to max out around 500k.   

Status: Investigating

Hi, 

According to my research, here’s the limitation document for the exporting rows from visuals in the Power BI:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#considerations-...

https://community.powerbi.com/t5/Desktop/Export-report-in-xlsx-format-with-Desktop-version/m-p/47538...

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

Hi, 

According to my research, here’s the limitation document for the exporting rows from visuals in the Power BI:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#considerations-...

https://community.powerbi.com/t5/Desktop/Export-report-in-xlsx-format-with-Desktop-version/m-p/47538...

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

briguy441
Regular Visitor

I apreciate the post, but not helpful.  I already had read those links, and they do not apply to the problem I described, that is why i posted it here.

v-robertq-msft
Community Support

Hi, 

In this case, if you didn’t reach the data rows limitation and want to get a solution for this kind of exporting problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin