Forum Discussion
Issues with CSV files
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
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.
5 Replies
Can you post your Advanced Editor code?
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.
Great, how do I submit it as a bug?
