Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data Missing in some cells when loading in Power Query

Hi, When I am loading data from a CSV to Power Query (and later to PowerBI Desktop) then some columns only show partial data. In my example I have sales data where 2 columns are most of the time ...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
3 years ago

Hi Anonymous ,

 

When you look at them individually, is the data all there? Is some data only lost when the whole folder is loaded?

 

And PowerQuery is case-sensitive, so make sure your column names are exactly the same as the ones in the CSV.

 

Best Regards,
Winniz

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Winniz,

     

    thank you for your message.

    The data is all there in the CSV, where I would expect them.

    The header names are not modified from my side. I am accepting them as they are.

     

    What factor is a changing amount of columns? In some months particular fields are not filled and these would then not be exported?

    Best Regards,

    Matthias

    • Moni_Moni's avatar
      Moni_Moni
      New Member
      2 years ago

      Hello, Did you get this solved? I also load CSV file and partial data is missing...