Forum Discussion
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), ...
Thanks MFelix for your help!
What I did to solve the issue was following this article to change the computer setting so that it accepts comma as delimiter as default: https://resrequest.helpspot.com/index.php?pg=kb.page&id=279
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
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