We are happy to announce that the Tabular Model Definition Language (TMDL) has now reached General Availability (GA)!

We are excited to announce you can now write DAX queries with DAX query view for web from published semantic models in the workspace.

Here’s another one of my occasional posts about books I’ve been sent free copies of. Full disclosure: as always, these aren’t reviews as such, they’re more like free publicity in return for the free books and I don’t pretend to be unbiased; also the Amazon UK links have a affiliate code in that gives me … Continue reading Power BI/AI […]

In recent my posts on the Command Memory Limit error and the partialBatch mode for Power BI semantic model refresh, I mentioned that one way to avoid memory errors when refreshing large semantic models was to run use refresh type clearValues followed by a full refresh – but that the downside of doing this was … Continue reading Power BI […]

One of the great things about the SQLBits conference in the UK is the way that all the session recordings are made available for for anyone to view for free on their YouTube channel. All the recordings from the 2024 conference have now been posted and it’s a goldmine for anyone who wants to deepen … Continue reading SQLBits Power BI/Fabric […]

We are excited to announce the July 2024 release of the on-premises data gateway!

Today I’m going to share my solution to a question I found on the MrExcel forum. It’s an interesting problem. https://www.mrexcel.com/board/threads/power-query-to-determine-consecutive-and-non-consecutive-dates.1261496/ Let me briefly explain the problem. The Problem We have the following table, which contains the source data.  Each row […]

Concluding my series of blog posts on seemingly harmless things you can do in a Power BI report that can lead to performance problems and the “This visual has exceeded the available resources” error (see also “Calculate(), Filter() and DAX memory usage” and “DAX measures that never return blank“), in this post I’ll show how … […]

Welcome to the July 2024 update. Here are a few, select highlights of the many we have for Power BI. Customize your reference layers in Azure Maps visual, DAX query view is available in live connect and an update to Power BI enhanced report format (PBIR). There is much more to explore, please continue to read on!

The Windows installer for Analysis Services client libraries will be retired next year.

Following on from my earlier post on the Query Memory Limit in Power BI, and as companion to last week’s post on how a DAX antipattern using Calculate() and Filter() can lead to excessive memory consumption by queries (and therefore lead to you hitting the Query Memory Limit), in this post I want to look … Continue reading DAX Measures That […]

Following on from my last post on the Query Memory Limit in Power BI, in this post I want to look at one of the most common DAX antipatterns and its effect on query memory usage: filtering on a whole table, rather than an individual column, in the filter parameters of the Calculate() function. A … Continue reading Calculate(), Filter() And DAX […]

Updated June 2024 We update this blog article regularly to keep track of how Microsoft is progressing on its strategic journey in building a world class BI platform.  Gartner released the 2024 Magic Quadrant for Analytics and Business Intelligence Platforms in June.  As expected (by us at least), Microsoft is [...]Read More »

We are thrilled to announce that, for the seventeenth consecutive year, Microsoft has been positioned as a Leader in the 2024 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms.

Continuing my series on Power BI memory errors (see part 1, part 2 and part 3), in this post I’ll look at the query memory limit which controls the amount of memory that an individual query can consume. This is a subject which I’ve talked about in a few blog posts in the past: hitting … Continue reading Power BI Semantic Model Memory Errors, […]

Welcome to June! We are excited to announce the 3000.222.10 version of the on-premises data gateway.

When you’re using Excel workbooks as a data source in Power Query in either Excel or Power BI you may encounter the following error when trying to connect: DataFormat.Error: File contains corrupted data. There are three possible causes of this error that I know of, two of which are well documented. First, the file may … Continue reading The […]

Enhancing team collaboration and automation is crucial for any enterprise BI development, which is the primary goal of Power BI Desktop developer mode. The Power BI enhanced report format (PBIR) for Power BI Project files (PBIP) represents a significant milestone in achieving this goal. This new report format offers source control-friendly file […]

Welcome to the June 2024 update. Here are a few, select highlights of the many we have for Power BI. You can now download large semantic models, Power BI enhanced report format (PBIR), and Subfolder support in Power BI Report Builder.  There is much more to explore, please continue to read on!

Everyone is excited about Power BI Copilot, and the newly-announced preview of being able to use Copilot to ask questions about all the data in your semantic model rather than just what is shown in a report is a massive step forward. However amazing the LLMs used behind the scenes are, though, the quality of … Continue reading Get Better Results […]

You can now ask Copilot for data from your semantic model! Check out the announcement to learn more about this exciting new preview feature for Power BI Copilot.

Continuing my series on Power BI model memory errors (see part 1 and part 2), in this post I will look at the Command Memory Limit which restricts the amount of memory that XMLA commands like Create, Alter and most importantly Refresh can use. If you’ve ever been told that your semantic model should consume … Continue reading Power BI Semantic […]

Last week we published a new version of our Mailchimp Power BI App: Analytics for Mailchimp (previously known as “Mailchimp Email Marketing”). The app is available on Microsoft AppSource. Analytics for Mailchimp is a Power BI app that connects to your Mailchimp account and analyzes the performance of your campaigns. An active Mailchimp account […]

Can you believe how amazing and hectic March has been?! So many community members got to experience some major conferences all next to each other. We had the MVP Summit,…

Last week I again had the pleasure of being invited by Rob Collie to be on his podcast Raw Data by P3 Adaptive.  For those that are not familiar with my story, I identified Rob as a leader in the Power Pivot/Power BI space very early on (back in the [...]Read More »