Please help

[Tronnie90]

Hello I am a master student in the business intelligence program. I am running into an issue loading my data into power bi. When I go to a Column I see a list may be incomplete error I hit load more it loads but it still only shows the one country not all of them. 

[Tronnie90]

Thank you i figured that out! lol I won't make that mistake again

[amitchandak · Accepted solution]

@Tronnie90 , I am assuming you are talking about power query. That is not an error, Power query only loads sample data. And suggest values based on that.

Check you have not filtered any data. As filter in power query remove the data for next steps and final data

Save and close, come out and check; in the data view.  The data view has complete data