Forum Discussion
Paginated Report export to CSV prepends dataset table name to each column
I'm using a paginated report to export a flat csv file of a dataset table. If I export the paginated table to excel- the column headers are as expected. However, if I export the paginated tab...
Hi, I have the exact same issue been driving me wild trying to find unsuccessful workarounds. Did you ever find a resolution?
in power automate use a compose. Then in compose use an expression like replace(body('Export_To_File_for_Paginated_Reports'),'Blah_Blah_','') to remove whatever your dataset name is from the headers. Then in the next step just make sure you use the output from the compose to export/create your file