Appending Query: Nulls

[Anonymous]

Good Afternoon,

I have attempted to append new data to an existing query for the first time, I am new to PBI!

Nulls are showing in my "Date" column, the format is the same within my original query and appended query.

Is this a common error?

Any assistance would be appreciated.

Kind regards

Sean

[Anonymous]

Usually this occurs if the field is not in the first table but is in the second table. PQ creates the field on the first table and fills it with nulls. Are you sure that Date is in both tables? Remember that PQ is case sensitive.