Forum Discussion
Import data from web with multiple tabs and no changing url
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
- Anonymous8 years ago
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
1 Reply
- AnonymousNot applicable
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