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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Table "sparklines" cause export to Excel error when used in combination with field parameters

This seems to only happen when I add more than 3 or so field parameter values to a table that has a sparkline. When I try to export to Excel, I get an error "Error exporting data. Sorry, we couldn't export your visual right now. Please try again later". 

 

If I remove the sparkline, it succeeds in exporting without error with the field parameters in the table. If I remove all but 1-2 of the parameter values and keep the sparkline, it also succeeds. It seems to only be when I have more than 3 field paramter values in combination with a sparkline that it has issues. 

 

I understand this may be hard to reproduce on your end, but I have a PBIX I can share if you want. It has only sample data in it, so totally shareable (just not sure how to attach it, there doesn't seem to be an attach button).

 

It seems like a trivial issue, but the combination of tables + field parameters + sparklines makes for a really cool user experience, but in this case I'm trying to make something that is designed to help people export to Excel, so I can't use them together.

Status: Investigating
Comments
Anonymous
Not applicable

Hi @Anonymous ,

 

Based on your description, this appears to be a design conflict. This feature is not supported at this time.

Export data from a Power BI visualization - Power BI | Microsoft Learn

 

If you would like to suggest  feature improvements, you may  vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn