Forum Discussion
Helper ICreate region
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.
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 🙂
5 Replies
- SpartaBI
Community Champion
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
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
MehayDear 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
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 🙂