Forum Discussion

Chas2002's avatar
Chas2002
Icon for Helper III rankHelper III
8 years ago
Solved

Export to Excel with Totals

Hi Everyone, I researched before I came here and I see that Export w/Total has been a request since 2016. Created my Matrix table with sub and grand totals -- it looks great on desktop and Web ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    There are a lot of directions to go here and it's a little confusng.  If you have Software Assurance, Power BI Report Server (PBRS) will be free.  You can host SSRS reports in Power BI Report Server so this option will be nice as you can use Power BI and host SSRS report in PBRS.

     

    Alternatively SQL Server Reporting Services (SSRS) comes with SQL Server.  So if you own a SQL Server licenes you can install SSRS and use that.  You can host Power BI dashboards in SSRS as long as you're using 2016 and up.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Download the report in local. Open it in Power BI Desktop. I had data at date level in a table visual. I also had a date filter. I wanted the total row after selecting few dates from the date filter. 

Removed Date column from the table visual, so only the total column was visible. Then exported data to csv. 

This 

It worked for me, hope it helps.

But would be really helpful, if powerbi rolls out the feature to download totals. 

 

Regards,

[email protected]