Data Missing in some cells when loading in Power Query

[Anonymous]

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)

[v-kkf-msft]

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]

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]

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