Forum Discussion

PowerBiKitten's avatar
PowerBiKitten
New Member
11 months ago
Solved

Power Bi export to excel

 I am attaching multiple spreadsheets in Power Bi.  Creating a relationship.  I am trying to create a power pivot. I export this to excel.  however in excel my columns are not consoli
Need Help
  • Anonymous's avatar
    Anonymous
    11 months ago

    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.

Poojara_D12's avatar
Poojara_D12
Super User
11 months ago

Hi PowerBiKitten 

When you attach multiple spreadsheets in Power BI and create relationships between them, the model works fine within Power BI, but when you export the data to Excel, you may find that the columns are not consolidated into a single table as you expected. This happens because Power BI exports the data model as separate tables with their relationships intact, rather than flattening them into one consolidated view. If your goal is to have one combined dataset in Excel, you would need to either create a single consolidated table in Power BI (for example, by using Power Query to merge or append queries) before exporting, or by creating a summarized table in DAX (using functions like SUMMARIZECOLUMNS or SELECTCOLUMNS) that explicitly brings all the necessary fields into one structure. Once that consolidated table exists in Power BI, exporting to Excel will give you the unified view you’re expecting, instead of separate linked tables.