Import data from web with multiple tabs and no changing url

[Annur2001]

Dear Experts,

I am a newbie in Power BI but I keen to learn. I want to import data from a website. The list of data in that website is divided into four tabs and I want to import data in tab 1 and 2. I tried to use queries and get data from the web, but I only get the first tab instead of both tabs. I searched on youtube and on this forum too, I found mostly the guideline was about imported data from one tab with a different year. I do not think this will work for me. 

I copy the URL for ease to understand what my question is. The data that I need to import is a list of company name include the company code which in that website was divided by 2 tabs, the first one is a list of a company from number 1 - 10 and second one is from 11 - 555. I want to import that data to power BI. Please kindly help to solve this.

URL: www.sahamok.com/perusahaan-publik-terbuka-tbk-emiten-bei-bursa-efek-indonesia/

Regards

[Anonymous · Accepted solution]

@Annur2001,

You can use "Extact table from example" feature in Web connnector of Power BI Desktop May release, for detailed steps, please check the article and video below.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example
https://www.youtube.com/watch?v=-_GMCE1TLvQ&feature=youtu.be&t=10m17s

Regards,
Lydia