- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Live excel export not respecting "show items with no data" setting
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.
-
allyklee
on: Remove / Copy Visual issue - July 2025 Desktop Iss...
- stipa on: Error "[403.12–403.30] The name 'Lakehouse.Content...
-
klinejordan
on: URL is not filtering on field parameter
- MaAl on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on: URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
- zsombor on: Matrix Visual doesn't work with Field Parameters ...
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- New 8,050
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,248 -
Data Modeling
4,135 -
Dashboards
4,116 -
Report Server
2,116 -
Gateways
2,116 -
APIS and Embedding
1,966 -
Custom Visuals
1,790 -
Content Packs
525 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1