562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Start by either creating a new table of website URLs, or loading them in from an Excel workbook (which you will need to create):
Obviously you should use real website addresses!
Your aim is to get a single query showing all of the links to external websites containing in these URLs. Begin by doing the following:
|Create a parameter||Create a parameter to hold a typical website URL.|
|Load web data||Load any table of data from a typical website URL.|
|Apply your parameter||Change the query you've just written so that it loads data from the website whose URL is held in your parameter.|
If you look at your query you should see that it processes the HTML returned from a website using an M Html.Table function:
Step 2 of your query will start something like this.
Amend this to create a new column called External links which picks out all the <a> tags (ie the hyperlinks) which have href attribute beginning http:
You need to type this in very carefully!
Turn this query into a custom function, and apply it to your list of website URLs to show the external links for each website you've requested:
Your final query should show all your websites, and for each website all of its external links.
Apply your changes to return to Power BI Dekstop, then save this query as PBI web scraper, and close it down.
25 Aytoun Street