Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
biswasg
Regular Visitor

While using Get data with a csv file, data getting truncated to after column48

‎05-18-2020 06:48 AM

I am trying to pull in data from .csv file into power bi desktop.

My csv file has 51 columns of data.

However, after get data in powerquery, I only get upto columns 48. Columns 49-51 are ignored.

How do I get the entire sheet into power query?

 

Labels:
Message 1 of 3
925 Views
0
1 ACCEPTED SOLUTION
parry2k
Super User
Super User

‎05-18-2020 06:50 AM

@biswasg it is weird, open query in the advanced editor, and there will be value with columns = 48, change it to 51

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!



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.

View solution in original post

Message 2 of 3
923 Views
2 REPLIES 2
parry2k
Super User
Super User

‎05-18-2020 06:50 AM

@biswasg it is weird, open query in the advanced editor, and there will be value with columns = 48, change it to 51

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!



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.

Message 2 of 3
924 Views
biswasg
Regular Visitor
In response to parry2k

‎05-18-2020 08:08 AM

Thank you Parry. Your solution worked. Thank you.

Message 3 of 3
904 Views
0

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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

View All