Forum Discussion
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.
How do I get the entire sheet into power query?
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!
2 Replies
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!