By Alan Harman-Box

Power BI in Practice PowerQuery

I have the Power(query): Functions

In the last episode of I Have the Power, we looked at calling REST APIs via Custom Columns using M's Web.Contents function. Today, we're going to look at creating Functions in Power Query. Functionalisation As a reminder, we have so far translated text by calling Google's translation API via a Custom Column. However, we might find that we have many queries in our dataset that need some kind of translation; perhaps one query that is all in one language and… Read More

By Alan Harman-Box

Power BI in Practice PowerQuery

I have the Power(query): using Power Query to call REST APIs

Welcome to "I Have the Power(query)" - a new intermittent series here on the Burningsuit blog, delving into some of the more advanced use cases of Power Query, the oft-overlooked and sometimes maligned ETL engine for Power BI. Today, we're looking at APIs. [latestCourse] There are a whole host of web services available that can do all sorts of things with your data; from predicting the age, gender, or nationality of someone from their name (agify.io, nationalize.io, genderize.io), to getting… Read More

3 Responses