Missing Data when Appending

Question

I am having issues appending two data files together. Once I have appended the files, certain columns are missing data. It goes from showing data to just being blank, in different spots throughout the column.

I have read other suggestions to this issue and none have worked for me. I have the October 2018 version of Power BI Desktop. I do not use gateways, nor do I want to.

Any help would be much appreciated. Thank youas you can see P2019_09 is just missing data and does not show any amounts, even if it were to be 0.

anonymous · Answer

Hello,&nbsp;Is there a solution for this? I am having the same issue.&nbsp;&nbsp;

anonymous · Answer

With your 2 different tables.&nbsp; Do both tables have that column?&nbsp; Usually you get the result you have described when only one of the tables has that particular column.

tescobar · Answer

Yes, both tables do have that column. Its interesting, because the data typically disappears when there should be a value other then 0.&nbsp;

anonymous · Answer

Post some data files and hopefully someone can take a look at it.&nbsp; My organisations security prevents me from doing so.&nbsp; Hopefully by posting the data, someone can reproduce the issue and see the cause.

tescobar · Answer

Unfortunately, I am not able to post the data files I am using. Thanks for you input though!!

Forum Discussion

Missing Data when Appending

9 Replies

Related content

missing data

missing data

Generating Missing Data

Appending Data

Inferring Missing Columns and Imputing Missing Data