Forum Discussion

trevorw1329's avatar
trevorw1329
Regular Visitor
4 years ago

Missing appended data

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 woul...
Need Help
liuqi_pbi's avatar
liuqi_pbi
Resolver III
4 years ago

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!