Forum Discussion
Paginated Report export to CSV prepends dataset table name to each column
I've been trying to solve the same problem, I've not found a way round it specifically to display the column titles exactly as you want, but you can rename the cells in the table and call them whatever you want, just right click on the box with the actual repeating data cell and in properties call it want you want. Only Limitation is you can't have spaces.
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.