Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
@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
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:
Is it possible to pull data at this level? e.g each of the Select All options
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |