Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When exporting summarized data from a report visual to Excel, the first two rows show the filtering applied followed by a blank row. Is there any way to automatically omit these first two rows in the exported Excel file, i.e. without having to do it afterwards in the file manually or through a macro?
And the name of the resulting Excel sheet is automatically set as Sheet1. Is there a way to have this come out with another sheet name, without having to do it manually afterwards?
Would be greatly thankful for any good suggestions. Thanks!
Solved! Go to Solution.
Hi @KlausW,
What I mean is currently above requirements are not achievable now.
Regards,
Yuliana Gu
is this still unachievable.. ???
This comes up as Solved in google, but this isn't a solution.
Hi @KlausW,
Is there any way to automatically omit these first two rows in the exported Excel file, i.e. without having to do it afterwards in the file manually or through a macro?
Is there a way to have this come out with another sheet name, without having to do it manually afterwards?
Unfortunately, there is no supported way to achieve above requirements automatically.
Regards,
Yuliana Gu
Hi again, and thanks for your response. When you say "there is no supported way to achieve above requirements automatically", does this mean that there could possibly be some "unsupported" way" to achieve the equired Excel output formatting?
Hi @KlausW,
What I mean is currently above requirements are not achievable now.
Regards,
Yuliana Gu
Hi again, and thanks. That't too bad, and it would be great if that could be implemented in later versions.