Exporting Power BI report to excel with sheet name populated as report name

[sqlguru448]

Hello,

I am trying to see if the Power BI report when exported from app.PowerBI.com can show the report name in the sheet name, this is possible when I do it from Power BI desktop but when exported from app.PowerBI.com the sheet name is named as "sheet1". Below is the screenshot.

This screenshot is when I export the report from Power BI desktop and the sheet name has report name displayed but I am unable to do same when I try to export from app.PowerBI.com

Can you please guide me if there is any workaround.

Thank you

[v-diye-msft]

Hi @sqlguru448 ,

Would you mind letting me know how did you export the whole report including all visuals in desktop? based on my test, I can only export the data within specific visual, and the csv exported is naming by the visual title, rather than report name.  when i do the same operation in service, the sheet name is "sheet1" same as your issue. but the workaround is download a pbix copy and then export the data.

Please kindly share the solution how to export the whole report with several report pages into excel. thanks!

[GilbertQ]

Hi there

As far as I know that is currently the way the Power BI Service works.

I would suggest looking at https://ideas.powerbi.com and voting for an idea.