Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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. ...
  • parry2k's avatar
    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!