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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
agagnon
Frequent Visitor

Issue adding CSV file using a folder as source

Hello,

 

I have been having an issue trying to add a new source of data to my model using a folder as the source.  When I try to add this file that has about 96,000 lines I keep getting the same error not matter what I try.  Through some investigation I have tried a few things which only baffle me further.

 

The image below is a sampling of the errors that I am getting.  To debug I went to line 29846 in the source file and I did not see anything wrong with it.  I then tried making it an Excel document and formatting it as a table which reveled something that was odd but not sure if it was the problem.

 

 

Snapshot of some errorsSnapshot of some errors

 

In this image you can see nearly every line in the document that is ok is a single line which is not expanded.  The line that is the issue for some reason is expanded and the cell in particular that seems to be causing the issue is selected.  What I found is that when looking at this in CSV format the "January-December 2019" text does not appear to show up unless the cell is expanded.  To be clear the line that starts with date "1/9/2019" is row 29846 that seems to cause the error.

 

Is there anything obviously wrong with the data on this row or anyway I can get around these errors?  I am frankly having a tough time even figuing out what the issue is never mind the solution!

 

What makes things more confusing is that if I import only that single line it seems to work.

 

First Error  Detail.png

1 ACCEPTED SOLUTION
agagnon
Frequent Visitor

If anyone stumbles upon this I found the answer!  The issue was that the data I was exporting from the accounting system had "carriage returns" in some of the cells which seems to upset PowerBI.  A quick google seach of "Remove Carriage Returns" results in many different ways to approach the issue and once I did that to my data file I was successfully able to use the data.

 

I hope this helps someone down the line!

View solution in original post

4 REPLIES 4
agagnon
Frequent Visitor

If anyone stumbles upon this I found the answer!  The issue was that the data I was exporting from the accounting system had "carriage returns" in some of the cells which seems to upset PowerBI.  A quick google seach of "Remove Carriage Returns" results in many different ways to approach the issue and once I did that to my data file I was successfully able to use the data.

 

I hope this helps someone down the line!

parry2k
Super User
Super User

@agagnon can you share CSV file causing the error wiht pbix file, may be change sensitive information to dummy data. would like to look at M script to understand where things are falling apart.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

I have created a new PBIX file and deleted alot of the data out of the CSV file and I am still getting the error.

What is the easiest way for me to share this with you?

@agagnon share thru google drive or one drive, or send directly by email. My email is in my signature. 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors