Welcome to our Power Query blog. This week, I look at another way to extract 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.KPIS.

On the final Friday of each month, set a challenge in Excel for you to solve over the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.

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.