Is this some known issue I am not finding? When I do export to .CSV, it works and I can open it in Excel. However, when I excel default file option (.xlsx), then it shows this error:
"Sorry, we couldn't export your visual data right now. Please try again later."
I also verified that export data to .xlsx still works for me(North Central US Data Center).
As we cannot reproduce the issue, I would suggest you create a ticket on Power BI Support for better assistance on this issue.
Did you ever get a solution to your problem?
I am facing same issue , and observed that the table with conditional formatting throws the same error, please find the screenshot attached herewith.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.