Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.