Export to Excel for conditionally formatted table fails
Submitted byAnonymouson07-15-201806:35 PM
Hi,
We have a few reports having one or more tables with conditionally formatted columns. All the conditional formatting is background colour scales formatting.
Export data functionality for such tables fails every single time. This is observed for all such tables across multiple reports published in power bi service.
If anyone encountered similar issues and knows how to fix it, please let me know.
I make a test using my PBIX file, but unable to reproduce this issue. What version of Power BI Desktop do you use? Could you please share a PBIX file that containing dummy data so that I can test?
After further testing we have identified that the issue is not cause by conditional formatting by when any column of the table is renamed with a blank space. Please find attached a sample Power BI report.
When the report is published to server, the tables with cannot be exported header will fail to export data as the status column is renamed as a " " (space). However the other table where the status column is renamed as "." will successfully export.
PS: Can't attach file, attaching an image. Simple report can be easily reproduced