Missing appended data

trevorw1329 · ‎08-03-2022

Hi,

I am working on appending a table containing counties and their lat/long to a table with more columns. The table I am appending to also contains county and lat/long fields so I thought this would be no issue. However, when I append the data it does not come through on the visualizations. There shouldn't be any filters excluding these rows of data so I am confused about why the data disappears once I try to create visualizations. I attached a photo of the table filtered by blank values to show the appended data as well as a photo of those columns unfiltered so that you can see the data comes through after applying from power query.

I would love to hear any potential solutions, my best guess is that it has something to do with the lat and long fields being categorized as geographic and the appended data isn't treated the same.

liuqi_pbi · ‎08-10-2022

Hi @trevorw1329

There are not same County values in the two photos you showed, so I don't know which data are missing after appending. My guess is that there are blank values for those rows in the original table before appending, so it also shows blank after appending. To check whether data is missing after appending, you can filter to some specific Counties for a test. For example, "Holmes County" has blank Age value, if you think its data is missing, check whether "Holmes County" has a value in Power Query Editor.

In addition, the table rows may be sorted by different columns in Power BI Desktop and in Power Query Editor, so it displays blank rows at the top, which make you think data is missing. You can sort them in the same way to check whether data is consistent.

----------------------------------------------------------------------

If this reply helps solve the problem, please mark it as Solution! Kudos are appreciated too!

lbendlin · ‎08-04-2022

no, there will be a different reason. append operations can be strict or forgiving. can you show your sample Power Query code? or ideally provide usable sample data (screenshots are not usable)