On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

Welcome back to this week’s edition of the Power BI blog series. This week, we review the updated menu bar in Power BI Service view mode.

Welcome to our Power Query blog. This week, I complete the extraction of data from a folder on SharePoint.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.HIERARCHYSTORAGES.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the REPLACEB function.

This week in our series about Microsoft Excel for Mac, we show how Excel for Windows and Mac differ regarding how each handles XML data.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at subscribing to reports on the last day of the month.

Welcome to our Power Query blog. This week, I look at how to access a folder of data on SharePoint.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.HIERARCHIES.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the REPLACE function.