Forum Discussion
Anonymous
6 years agoNot applicable
While using Get data with a csv file, data getting truncated to after column48
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. ...
- 6 years ago
Anonymous 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!
parry2k
6 years agoSuper User
Anonymous 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!
- Anonymous6 years agoNot applicable
Thank you Parry. Your solution worked. Thank you.