Reply
avatar user
Anonymous
Not applicable

Exporting Summarized Data

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
avatar user
Anonymous
Not applicable

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.

 

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.