Forum Discussion
Power BI Paginated Report Export as CSV
I have a paginated report that I have to export as a CSV and the column names contain spaces. in SQL I replaced all the spaces in the names with underscores, and then pagianted report column headers ...
i figured it out. added a 'Compose' action in the power automate flow:
replace(body('Export_To_File_for_Paginated_Reports'),'_',' ')
before . This works for my file as only the headers have underscores.