Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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 empty and I am not able to explain why. The data is already not present when opening power query to combine and optimize the data.

 

For this file type, I am loading data from an entire folder. in other cases I am loading a single file before inking these files together.

 

(I am sorry that I have had to remove some data to protect the privacy)

Further information:
Win10 10.0.19043 Build 19043

 

Feedback Type:
Frown (Error)

Timestamp:
2022-08-22T13:43:18.0225256Z

Local Time:
2022-08-22T15:43:18.0225256+02:00

Session ID:
1bdd51bd-e230-487b-aa44-99a8f96ecac5

Release:
August 2022

Product Version:
2.108.825.0 (22.08) (x64)

Need Help

3 Replies

  • 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...