Create region

[Mehay]

Dears, 

I'm trying to create a region column with existing list of countries, what would be the best and fast way of it? 

so i have all countries but need to identify its regions, like Europe, Asia, Africa, Middle East, North America, South America.

Or if anyone has pbix file with list of countries and regions, so i can just find relationship with my existing countries column.

Thanks in advance.

[SpartaBI]

@Mehay you can download the list from there (scroll down) until you see a download to csv. Better option is to just connect to it via the web data source and extract the table there (it will probably show up as options in the power query dialog).
https://worldpopulationreview.com/country-rankings/list-of-countries-by-continent

Showcase Report – Contoso By SpartaBI

      

[Mehay]

Dear @SpartaBI ,

thanks for your prompt respond.

by saying connect it via the web, you mean directly connecting powerbi with the link?

ive tried, unfortunately it doesnt give an option of that particular table, but probably saving it as excel and storing on a local drive C somewhere  and then connecting this excel to powerbi might work. 

Guess this is a soluation then, thanks!

[SpartaBI · Accepted solution]

@Mehay I think you should have html tables there available by the way this website looks. Not in front of PC, so can't make sure. There is also the tables by example feature in the web connector that you can use to extract the tables. It's a good practice. Mayve try a different website.

BTW, Instead of connecting to a static excel you can also just copy paste the table from excel to the 'enter data' option directly in the grid view and continue editing in PQ. 

P.S. don't forget to mark my messages as solutions for community visability and appreciate your kudos 🙂

[Mehay]

appreciate it mate, that should work! 🙂

[SpartaBI]

@Mehay my pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂