Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
@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