Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In the Visualizations panel of my report in the Power BI desktop app, I set a particular column to show items with no data. The report data shows as expected in app.powerbi.com.
However, when I go to More Options > Export Data and click Summarized data, 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.
Workaround provided here: https://community.fabric.microsoft.com/t5/Service/Live-Excel-export-not-including-rows-with-empty-ce...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @PeterTechDoc
Thanks for your feedback and workaround !
Best Regards,
Community Support Team _ Ailsa Tao