Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

export data from PB - format

Hi,

when exporting data from table in PB, all the data is pushed to single column.

Is there any way to export data to seperated columns like the original table in PB?

Help me please
Help required

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    What program are you trying to export to? In my experience, the csv output file is automatically separated by column when exporting to excel. Alternatively, you can manually set a delimiter as the commas separating the output data fields in your program of choice.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      This happens when clicking on export data icon from power bi. Users just want to open the exported file without saving. But the single given option is open as csv, and then the file is opened with all data pushed to one column.
      When saving the file locally as excel, the data is opened properlly with delimited columns.
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'm unable to replicate this issue on my machine.. having no problems with the data being separated regardless of how I export. Have you tried checking the regional setting for list separator?

        Control Panel > Region/Language options > Additional settings > List seperator set to comma.