Forum Discussion
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
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.
6 Replies
Can you please make sure when you are creating the relationships that they are on valid columns ensuring that you can see the consolidated view correctly?
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.
Hi PowerBiKitten ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.
Thank you.
Hi PowerBiKitten ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.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.
Hi PowerBiKitten ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.Thank you.
