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...
I'll probably just resort to exporting as excel - let the downstream users use that instead of a csv. I'm automating the process with a daily export, so need to keep it simple.
Other Option, which I've done in a couple of cases where I needed change the headers to was to use PowerAutomate to run the report, Parse the JSON and rebuild the CSV with the correct headers in PowerAutomate. Or just replace the headers. There's probably about 5 different ways to achieve it in a flow.