topic export data from PB - format in Report Server

export data from PB - format

Anonymous — Tue, 04 Jun 2019 08:18:29 GMT

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?

Re: export data from PB - format

Anonymous — Tue, 11 Jun 2019 11:46:58 GMT

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.

Re: export data from PB - format

Anonymous — Tue, 11 Jun 2019 08:52:15 GMT

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.

Re: export data from PB - format

Anonymous — Tue, 11 Jun 2019 11:40:41 GMT

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.

Re: export data from PB - format

Anonymous — Tue, 11 Jun 2019 11:56:18 GMT

Hi,
I could not find how to navigate to these settings. There are no "additional settings" under languages/region. I also did not find something like that under other categories.

Re: export data from PB - format

Anonymous — Tue, 11 Jun 2019 12:03:35 GMT

Windows 7

Select Control Panel
Select Region and Language
Click on Formats Tab
Click on Additional Settings
Locate the List separator
Change the separator from a full stop (.) to a comma (,)
Then click on Apply then Ok
Under the Formats Tab click on Apply then Ok
Test the Excel import again

Windows 8/10

To change regional settings,

go to Start > Control Panel > Regional and Language Options | (Windows 10 (Start >type Control Panel and press enter > Region))
Click Additional Settings
For Decimal Symbol, enter a dot:.
For List Separator, enter a comma:,