In theVisualizationspanel of my report in the Power BI desktop app, I set a particular columnto show items with no data. The report data shows as expected inapp.powerbi.com.
However, when I go toMore Options > Export Dataand clickSummarizeddata, and then select .xlsx with live connection, the generated file doesn't include the rows with the blank cells like it does in app.powerbi.com.
Those rows are included when export using the Data with current layout option or non-live .xlsx connection option. However, we would really benefit from the .xlsx with the live connection.