When exporting data from Power BI to Excel using the Power BI service, the sheet name is not customizable or dynamic. The exported data will be placed in a sheet named "Report" by default.
If you want to have a dynamic sheet name based on your requirements, you would need to export the data from Power BI to Excel programmatically using an API or custom code. Here's a general outline of the steps you can follow:
Retrieve the data from Power BI: Use the Power BI REST API or Power BI SDK to retrieve the data you want to export. You can query the data using the appropriate endpoints or methods based on your requirements.
Create an Excel file: Use a library or package (such as OpenXML or EPPlus in .NET) to create a new Excel file or open an existing one.
Add a new sheet: Use the library or package to add a new sheet to the Excel file. You can provide a dynamic name for the sheet based on your requirements.
Populate the sheet with data: Write the retrieved data from Power BI into the Excel sheet. Iterate over the data and populate the cells accordingly.
Save the Excel file: Save the Excel file with the populated data using the library or package you are using.
By programmatically exporting the data and creating the Excel file, you have control over the sheet name and can set it dynamically based on your needs.
Please note that this approach requires custom coding and knowledge of programming languages and libraries. The specific implementation details may vary based on the programming language and libraries you choose to use.