Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply. My SQL columns don't have spaces, but the output column headers MUST have spaces. This is not my choice, but a requirment of the third party that I am creating the CSV for to be imported into their system. Why they wrote a database import specificiation to require spaces in their column headers is beyond me, but my hands are tied. I think my only option at this point would be to move the data retrival and export into power automate where I can control the CSV output more granularly.

KarthigaM22's avatar
KarthigaM22
Frequent Visitor
2 years ago

Hi Anonymous ,

 

I have a similar requirement, did you get any solution?


Regards,

Karthiga

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    KarthigaM22 No in the interest of time I just exported it to excel and told the end user how to resave as a CSV. The only workaround I can think of is to use power automate to query the source data, then create a CSV file with custom headers. 

    • KarthigaM22's avatar
      KarthigaM22
      Frequent Visitor
      2 years ago

      Thanks for your response, have to follow Power automate approach then.