The Web.Contents() function in M is the key to getting data from web pages and web services, and has a number of useful – but badly documented – options that make it easier to construct urls for your web service calls. Consider the following url: https://data.gov.uk/api/3/action/package_search?q=cows It is a call to the metadata api (documentation … Continue reading Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code