Get Web Data From Complex Website

[Mooihoek]

Is Power BI able to retrieve data from a complicated website where there is a search facility to filter specific information?  For example the following site:

https://mylearn.vmware.com/portals/www/search/findCourse2.cfm?ui=www_edu&category=catalog&menu=searc...

[v-yuezhe-msft]

@Mooihoek,

I am not sure what data you would like to get in Power BI.

However, when you directly make a search from the above URL, you can input the detailed URL(the following URL is an example) into Web entry of Power BI Desktop to get data from the website.

https://mylearn.vmware.com/portals/www/search/results.cfm?ui=www_edu&category=catalog&searchtype=adv...



Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-to-web/

Regards,
Lydia

[Mooihoek]

Sure easy to go to an individual page like that and pull the data but thats not what I'm after. If you go back here: 

https://mylearn.vmware.com/portals/www/search/findCourse2.cfm?ui=www_edu&category=catalog&searchtype...

Is it possible to pull data at this level?  e.g each of the Select All options

[v-yuezhe-msft]

@Mooihoek,

You would need to contact VMware support to check if it has OData feed available or how to use its API to retrieve data, it is possible to connect straight to the OData feed from Power BI Desktop or use the web entry in Power BI desktop to connect to API.

And there is an example about connecting API in Power BI for your reference.
API Strategies with Power BI

Regards,
Lydia