Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello all,
could you help me how can I export table from service to excel with the summary row?
Thank you, Lucy
Solved! Go to Solution.
HI @lfil ,
You can export summarize records on power bi service, but it is impossible to export with the total row that power bi visual created.
Export the data that was used to create a visualization
In my opinion, I'd like to suggest you create a calculated table to add summary total rows, then you can export the underlying data from this table to achieve your requirement.
Regards,
Xiaoxin heng
HI @lfil ,
You can export summarize records on power bi service, but it is impossible to export with the total row that power bi visual created.
Export the data that was used to create a visualization
In my opinion, I'd like to suggest you create a calculated table to add summary total rows, then you can export the underlying data from this table to achieve your requirement.
Regards,
Xiaoxin heng
Thank you 🙂🤗
Hi @lfil ,
I'm afraid but this feature is still not available in Power BI.
This much needed feature has been provided as an idea to Power BI and you vote for it. Link
As an alternative(not something you would like but is the only option right now), you can manually calculate the total in excel using excel formulae.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 48 | |
| 48 | |
| 44 | |
| 16 | |
| 15 |