Forum Discussion
formatting matrix export to excel
Hello,
When I export this matrix to Excel
The export appears as two lines. Is there a way to just have one line? I would like to remove the line with R?
Hi , MikeSolvesBI
According to your description, when you export excel in Power BI Service, it return two rows.
I test in my side , the result is the same as yours.
For exporting Excel in the cloud, the format of the export is currently written directly in the program by the backend, and there is no open custom interface. Therefore, a fixed row cannot be deleted.
Sorry, if you don't need this line, you may need to delete it manually or you can use other third-party tools to implement bulk automatic deletion.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi , MikeSolvesBI
According to your description, when you export excel in Power BI Service, it return two rows.
I test in my side , the result is the same as yours.
For exporting Excel in the cloud, the format of the export is currently written directly in the program by the backend, and there is no open custom interface. Therefore, a fixed row cannot be deleted.
Sorry, if you don't need this line, you may need to delete it manually or you can use other third-party tools to implement bulk automatic deletion.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly