Export to Excel button at report

Hello

I have a solution for that, I do it as follows

1 - I copy the data model from Power BI to Excel, with this I mean Power Query queries and all Dax measures or calculated columns

2 - Charge the data you need to export from Power BI into tables within Excel spreadsheets

3 - Upload the Excel file to One Drive Business or Sharepoint site

4 - In Power BI Service from a workspace I give the option "New / Upload a file"

5 - I select the source from One Drive or the Sharepoint site and choose the Connect option, this allows you to put program update to the Excel dataset and therefore to the tables within the Excel file (the Excel file must have data model in Power Pivot to allow you to put scheduled update) I put the same updates as I have in the Power BI

6 - From One Drive or Sharepoint I select the Excel file and give it share (I choose the permissions you need for that case) I disable the "edit content" option to ensure that the dataset is always updated so that they have the Excel file open

7 - I copy the link that throws me into the action of a button inside Power BI so that the user arrives at an Excel window online where he sees the tables with the same data as there is in the report and from there he can save a copy on his computer

I hope this help will help you, even serves when sharing public on the web