topic Re: Data Missing in some cells when loading in Power Query in Power Query

Data Missing in some cells when loading in Power Query

Anonymous — Mon, 22 Aug 2022 14:07:01 GMT

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)

Re: Data Missing in some cells when loading in Power Query

v-kkf-msft — Thu, 25 Aug 2022 02:46:50 GMT

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

Re: Data Missing in some cells when loading in Power Query

Anonymous — Thu, 25 Aug 2022 07:15:32 GMT

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

Re: Data Missing in some cells when loading in Power Query

Moni_Moni — Thu, 21 Sep 2023 18:06:05 GMT

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