Export power bi table in excel and putting some parameters

[KevinSV]

Hello everyone, I have few questions about the export in excel of my report. 
Actually I export a table visual :

Here is my questions : I want to add some parameters which can automatically give me the export without modify it. 

When I export can i change the name of the page of excel (Export by default) without do it on excel like a parameter before the export : 

Can we remove automatically the row where it explains all the filter apply to the table : 

AND can we remove the total row in the export without remove it on the report ? 

Thank you for your help 🙂 ! 

[v-ssriganesh · Accepted solution]

Hi @KevinSV,

Thank you for reaching out to the Microsoft Fabric Forum Community.

To address questions regarding the Power BI to Excel export:

Change the name of the Excel sheet (Export by default) before exporting :

No, Power BI does not allow you to set a custom sheet name before export. You have to rename it manually in Excel after export.

Remove the filter summary row automatically:

No, Power BI automatically appends the filter summary, and there is no built-in option to exclude it during export. However, you can use Power Automate to post-process the file and remove that row.

Remove the total row in the export without removing it from the report:

No, if the total row is visible in the report, it will be included in the export. The only workaround is to create a separate table visual without totals specifically for export.

Workaround:
If you want an automated process, consider using Power Automate to modify the exported file by removing unwanted rows and renaming the sheet programmatically.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[SamWiseOwl]

Hi @KevinSV 
Have you considered sending the data using a Power Automate flow?

This blog covers extracting the DAX that produces the measure and then sending it as a CSV via email:
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Extracting-data-from-visuals-using...

Or when you are happy with the data connect an Excel report to the data:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets