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.

Welcome to our Power Query blog. This week, I look at how to remove a random number of rows before useful data.

Welcome to our Power Query blog. This week, I look at how to view the errors for each row.

Welcome to our Power Query blog. This week, I look at the differences in the way that the ‘Standard’ button works on the ‘Transform’ and ‘Add Column’ tabs.

Welcome to our Power Query blog. This week, I look at merging columns to show that not all ‘Merge Columns’ options are born equal.

Welcome to our Power Query blog. This week, I look at whether to append or merge when combining data.

Welcome to our Power Query blog. This week, I look at creating a bridge table.

Welcome to our Power Query blog. This week, I look at how M and culture can go together.