Power Bi export to excel

Hi PowerBiKitten ,

Thanks for reaching out to the Microsoft fabric community forum.

The behavior you're seeing is normal because the Export to Excel option only exports either the underlying or summarized data from a particular visual. It doesn't include the complete data model, relationships, or measures from Power BI, which is why the columns aren't consolidated in Excel.

If you want to keep the model structure, including relationships and measures, in Excel, try using the Analyze in Excel feature. This lets you connect your Excel workbook directly to your Power BI dataset so you can create PivotTables and analyze your data with all the relationships and measures intact.

You can refer to the official documentation here:  Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

If you prefer a static export, you would first need to consolidate the data or build a summary table in Power BI and then export that to Excel.

Hope this helps clarify the difference and gives you the path forward. please feel free to reach out for further questions.

Thank you.