Forum Discussion
export with summary row
Hello all,
could you help me how can I export table from service to excel with the summary row?
Thank you, Lucy
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
3 Replies
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.
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!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 🙂🤗
