We all work with Power Query to transform our data for use in Power BI. The best part of the transform proces is the ability to automatically perform tasks, which previously required a lot of manual work. This is of course not what you want, but it is not always obvious how to deploy Power Query to solve these issues. In some cases an own written custom function can be the saving grace!

In this session we demonstrate how to import data from an online source, containing information about movies. We use a custom function, that allows us to select the data we need.