Issues with CSV files

[gavinhuet]

Hi,

If I have data in a csv file it imports nicely.

ColumnA,ColumnB

"R1C1","R1C2"

The first issue is that if I swap the columns around and get data again I am prompted to override the existing the dataset, the columns are ignored and the data is imported as though it is the original file - no warnings.

ColumnB,ColumnA

"R1C2","R1C1"

"R2C2","R2C1"

Imports as

ColumnA,ColumnB

"R1C2","R1C1"

"R2C2","R2C1"

The second issue is that if I then add ColumnC, Get Data again, I am once again prompted to override the existing dataset.

This time however it says that there is an error and the data is then lost.

Surely at that point you should be given the option to undo the change?

Kind regards

Gavin

[ankitpatira · Accepted solution]

@gavinhuet I can replicate your issue. You should submit this as a bug. But I would suggest you go down the approach of using power bi desktop to import csv file and then publish to power bi service.

[gavinhuet]

Great, how do I submit it as a bug?

[Greg_Deckler]

Issues forum:

https://ideas.powerbi.com/forums/360879-issues

[gavinhuet]

Done : https://ideas.powerbi.com/forums/360879-issues/suggestions/15823327-updating-csv-data

[Greg_Deckler]

Can you post your Advanced Editor code?