Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I want to understand why my pivot table in excel doesn't work properly but is ok in Power Bi
I have 3 tables linked
One with header and another with sub header
In Excel when i create my pivot table it show me all the subheader for each header .....
Thanks
Hi @nicolast29 ,
This is because in Power BI there is a model relationship between your two tables, whereas in excel there is no model relationship so it will export the two columns as a Cartesian product, if you want the data from the layout on the pbix file you can publish the report to the service by selecting that visual object, clicking export data and choosing to export in the current layout.
For more details, please refer: Export data from a Power BI visualization - Power BI | Microsoft Learn
Troubleshoot the connection from Excel to Power BI data - Power BI | Microsoft Learn
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi
thanks for replying
For me i do a model relationship
You can see it if you dowload the file
Or maybe i think wrong ? Can you tell me
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |