Known issue - Export to Excel using live connection with show items with no data turned on fails
You can have a visual that has one or more grouping columns and also has Show items with no data enabled. If you try to export to Excel using a live connection, the export fails.
Status: Open
Product Experience: Power BI
Symptoms
When you try to export to Excel using a live connection, the export fails with a generic error message.
Solutions and workarounds
To work around the issue, on the visual, turn off Show items with no data. You can then export to Excel and then turn the setting back on. Changing the setting doesn't change what is exported.