This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Power BI (160 exercises)
Topic ==>	Custom functions (3 exercises)
Level ==>	Harder than average
Subject ==>	Power BI training

Use a custom function to extract and combine the external links from websites

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:

Task	Notes
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: