Forum Discussion

Mehay's avatar
Mehay
Helper I
4 years ago
Solved

Create 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, A...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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's avatar
Mehay
Helper I
4 years ago

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's avatar
    SpartaBI
    Community Champion
    4 years ago

    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 🙂