Data not loading completely in Power Query

[Anonymous]

I am trying to load data from Snowflake, and when I view it in Power Query - it does not give me all values - however when I load it to Power BI - the visuals show all values. Could someone please help me out here?

Below is Power BI visual snapshot (Example : Australia in Power BI is loaded - however it's not seen in Power Query)

Column stats from Power Query as follows

Count	12285272
Error	0
Empty	157697
Distinct	230
Unique	1
Empty string	0
Min	-- Select one --
Max	ZW

Below is Power Query snapshot which is copied to excel - it doesnt show all the distinct 230 countries

AU	10250805
NZ	1848411
US	11201
GB	7841
CA	853
-	849
AT	790
IE	647
SG	557
PR	428
ZA	344
HK	294
CF	198
MY	165
AE	162
NL	159
IN	149
FR	140
DE	122
ID	121
CN	110
PH	103
ES	102
PG	89
CH	86
FJ	84
MX	76
BR	68
AZ	67
GU	57
LK	56
IT	55
JP	51
EE	51
SA	48
AF	46
NC	44
-- Select one --	44
SE	42
TW	42
DK	39
IL	38
NO	38
UM	37
TT	37
AR	35
BS	34
GE	34
TH	33

[v-chuncz-msft]

@Anonymous 

You may check this post and create a support ticket for assistance if necessary.