Welcome to our Power Query blog. This week I look at some of the M functionality for dealing with files.

Welcome to our Power Query blog. Last week’s blog looked at solving a particular problem by using DateTime.AddZone(). This week, I look at some of the M functionality for dealing with time zones.

Welcome to our Power Query blog. This week, I look at some issues when dealing with extracted dates.

Welcome to our Power Query blog. This week, I look at an example where one column contains both header and detail data.

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.

Welcome to our Power Query blog. This week, I look at a neat way of linking tables with similar key data.

Welcome to our Power Query blog. This week I look at M functions List.Skip() and List.Alternate().

Welcome to our Power Query blog. This week, I look at how to view a complex JSON record.

Welcome to our Power Query blog. This week, I look at how to view links in a webpage.

Welcome to our Power Query blog. This week, I look at how to update data in an SQL database.