Web scraping non-tabular data not working

[HDBI]

Hi,

I'm trying to pull country exposure data from morningstar.com (available to the public) and have researched and tried numerous blogs but cannot get this to work.

1. If you look at image 1 below, this shows the ETF "WDIV" in the "Portfolio" section on the morningstar.com website.

2.  If you look at image 2 below, I need to click on the "Country" button to see the equity exposure % by country.  You can also see that there are several pages containing country exposure %s with only the first 10 shown so I'd need to loop through all country exposure pages in order to ensure that all countries and % exposures are pulled into power bi.

Using the standard GetDate>Web doesn't work as this data is not in an available table.  Additionally, trying to create a table using examples doesn't work as it comes up blank.  I have also tried to isolate in power query in the html based on some blogs that I have read but nothing has worked so I am obviously doing something wrong.

Do any of you know how to do this (ie - pull all pages of this country exposure %) into power bi?

Please let me know if you have some time and thank you!

Dan

IMAGE 1:

IMAGE 2:

[amitchandak]

@HDBI , check if connect by example can help

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-to-web-by-example

[CDPM]

@HDBI any ideas based off of same day reply from @amitchandak; I am stuck in similar situation. Thanks!

[HDBI]

Hi - thank you for your response.  I have tried that approach and nothing really shows up in the webpage screen (see yellow scriggly line below) and even when I search for certain keywords, etc in "Column 1", I keep getting the "No CSS selector was found for the sample values you provided in the following column(s):  Column 1" error.  I've tried every reference to "Country" that I could find in the dropdown....

Any suggestions or do you know another way to do what I'm looking to do?

Thanks,

Dan