Exporting Summarized Data

[Anonymous]

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!

[Anonymous]

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.