Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Exporting Summarized Data
08-23-2023
06:30 AM
Hello! I have a powerbi online where i am trying to do a live connection, to do this i have to export the summarized data, but when i export the summarized data it takes away the blanks that are in my data. I need my blanks to still show, so they will show up in my live connection data. Any help on this would be very appreciated!
1 REPLY 1

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024
05:22 AM
When you export data from Power BI, especially when summarizing or aggregating it, blank values may be excluded.
In your data model, consider creating a dummy record with a specific value to represent blanks. This way, when summarizing or exporting data, you have a placeholder for blank values.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-21-2025 06:25 AM | |||
07-07-2025 10:05 PM | |||
04-12-2024 06:09 AM | |||
03-21-2025 07:36 PM | |||
07-10-2025 02:35 AM |