PowerBI Service export data "unsupported blank column name" problem

[Anonymous]

Dear community,

When I tried to export "Summarized data to .xlsx (Excel)" in PowerBI Service, it showed error message "Your data contained an unsupported blank column name." But it works successfully when export "Summarized data to .csv". How can I solve it?

[v-qiuyu-msft]

Hi @Anonymous, 

The same issue has been reported before internally: CRI 87202812. Please check there is a column in one of the tables with a name that is a blank. Some time ago, power bi was not checking for this kind of anomaly, even if it should of from the implementation. Please type column name instead of blank name then text again. 

Best Regards,
Qiuyun Yu