Power query count differs from data model table

[jjl007]

I'm stuck.  I combined three large excel-sourced Power Query queries into one combined query using Load To "connection only" and then in final step after combining went to Load To: and unchecked Load to Data Model.  My power pivot model worked fine until I did a Refresh of the query (of combined three queries). The refresh shows the correct count, say 1.2m records in Power Query but my data model in Power Pivot shows a count of only (say) 1m, 200K less records. I have refreshed both from power Pivot (data view) and from within Power Query a couple times. Power Query shows the 1.2m records but Power Pivot / Data View shows only the 1.0m.  Can anyone see what I need to do to get the full 1.2m count into Power Pivot?   Thanks for all your support.   Jeff

[PhilipTreacy]

 @jjl007 

Hi Jeff,

So you're doing this in Excel?

If you've unchecked the Add this data to the Data Model box then the query results won't get loaded into Power Pivot.  So how have you gotten the data into PP?  I'm a bit unclear as to what data you are looking at in PP.

Regards

Phil