Exporting to Excel Isue

[klaisjohn]

I am getting this message when attempting to export data, I could export data before. I didn't change any settings.  Any assistance/advise would be very helpful☺.

Could this potentially be a temporary system issue???

[v-pgoloju]

Hi @klaisjohn,

Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @klaisjohn,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Pragati11 and @zenisekd  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[zenisekd]

any chance you have exceeded the export data limit? 

[klaisjohn]

Is there a limit for this? 🤔

[zenisekd · Accepted solution]

• When exporting data from a report visual to .xlsx (Excel), the maximum number of rows you can export is 150,000.

• When exporting to .csv, the limit is 30,000 rows. 

• For matrix visuals exporting with “Data with current layout”, the limit is 150,000 data intersections. Because a “row” in a matrix can have multiple intersections, the effective number of rows you see in Excel may be smaller. 

• When using DirectQuery, there is an additional limit: the export request is capped at 16 MB uncompressed data. This can further reduce the number of rows you actually can export.

  However, usually you get a friendly warning that the rows have been reduced for the export...

[Pragati11]

HI @klaisjohn 
Just checking. Is the excel export enabled in Power BI desktop for this report? Did something change recently on the report side or on the data side?

[klaisjohn]

Hey Pragati, Thank you for your response ☺, Like i said in the post, I have not made ant adjustments to the settings. Even doesn't know where the settings are, and I am not a techy enough to mess with that area.

Good day!

[Pragati11]

HI @klaisjohn 
Is someone else the owner of the report and you have been given access to it?