Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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), the report suddenly does not recognize the columns of the new file, so all data is still in one column.

 

The 2 files, new and old, should be exactly the same, in terms of format. Strangely enough, when I copied the old CSV file and use that copied file as input (just for testing), Power BI also cannot regonize that copied file either!

 

Anyone knows what are the causes of this issue? Thanks!

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

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

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.