Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

CSV file input

Hello all,   I have an issue with a Power BI report, which input file is CSV (with comma delimiter). When I changed the data source to the new CSV file (every month we need to update the dataset), ...
Need Help
MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

Go to the query editor and check the first step (Source) in there you can check wht are the delimiter and how the file is opening.

 

I add a similar problem due to some changes on the regional settings, and this first step was incorrect.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi MFelix,

 

I checked and the setting of the Source query (file origin, line breaks, delimiter) are kept the same. Am I suppose to change any settings of the Source querry?

Thanks,
Van

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Anonymous,

     

    And does it all fit with the file you have? As I said I had one simple change that affected my CSV inputs, and had to make some changes to that.

     

    Did you tried to do a new PBIX file based on the CSV and check if PBI does it ok? If everything is ok then you can replace the first line of your previous file by the one on this new PBIX file.

     

    Regards,

    MFelix