Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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.

marcl1

Unable to export 'Data with current layout'

Submitted by Helper II on ‎08-02-2022 08:19 AM

I have a user with an export issue that occurs with a table in our report.

Clicking the three dots > Export data > Data with current layout > Export, the client finds that although the 'Exporting data' popup appears, the process quickly fails with 'File couldn't be created'. Using the 'Summary data' option works just fine.

The export size should be around 7000 rows… He said to me that last month it was running fine !

The user has viewer privileges, but on my performant machine also with admin privileges I get the same error.

We are in a premium workspace.

 

Any ideas?

Status: Delivered

Hi @marcl1 

For Data with current layout , export has a line limit of 150,000 lines . @Anonymous  I tested the scene you mentioned , there is no limit on the number of columns, maybe my data is not enough. You can raise a support ticket if you have a Pro license.

Ailsamsft_0-1659598809893.png

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
15 Comments (15 New)
Comments
PowerBIPerson42
Frequent Visitor
‎08-04-2022 08:44 AM

Hi @Ailsa-msft 

I'm also having the exact same issue as the above comments. If I have more that 13 columns I and others on my team receive the "Executing the Query for the Export Data operation resulted in an error" issue screenshotted above. As soon as I cut the matrix down to 13 columns I can export again. I can export fine from other visuals and everything else appaers to be working fine.
Thank you!

emcdermid
New Member
‎08-10-2022 12:29 PM

Hi @marcl1 and @v-yetao1-msft m

We have just encountered the same issue on a report that has been exporting successfully for a year.  I am able to export if I cut down the columns down, as noted above.  But if I use filters to reduce the data to just one row, and keep the columns as is, we get the error.  Did you find a solution to this issue?  Thanks,

marcl1
Helper II
Helper II
‎08-10-2022 10:23 PM

@emcdermidi've started the process of a ticket with pro license : ii'm in discussion with mindtree for pbix & log : hope we'll get soon smth

Annabel
New Member
‎08-15-2022 06:36 AM

I unfortunatly have the same issue, when drilling down in matrix, adding more columns, export is not possible when 14 or more columns are showing. When I remove columns from report to 13 or less exporting has no issues.

ashtondsa
Regular Visitor
‎08-18-2022 02:09 AM

I have recently come into this issue myself. It was working fine previously but it seems to have started this month. For us we noticed it from 15/08/2022.

 

The issue is isolated to matrix. I have tested the above and if the column is less that 14 it works.

Idea Statuses