cancel
Showing results for 
Search instead for 
Did you mean: 

Data not loading completely in Power Query

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)

divyabhandari_0-1593751793905.png

 

Column stats from Power Query as follows

Count12285272
Error0
Empty157697
Distinct230
Unique1
Empty string0
Min-- Select one --
MaxZW
 

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

AU10250805
NZ1848411
US11201
GB7841
CA853
-849
AT790
IE647
SG557
PR428
ZA344
HK294
CF198
MY165
AE162
NL159
IN149
FR140
DE122
ID121
CN110
PH103
ES102
PG89
CH86
FJ84
MX76
BR68
AZ67
GU57
LK56
IT55
JP51
EE51
SA48
AF46
NC44
-- Select one --44
SE42
TW42
DK39
IL38
NO38
UM37
TT37
AR35
BS34
GE34
TH33

 

Status: New
Comments
Community Support

@divyabhandari 

 

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