Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Annur2001
Regular Visitor

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

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors