Power BI

As a Power BI administrator you want to see what’s happening in your tenant right now: who’s running queries, which datasets are refreshing and so on. That way if a user calls you to co…

Late last year I was spending some vacation days playing with one of my favorite personal data sets[1], and I realized I needed a better date dimension. So I asked for one. A bunch of folks from th…

When used in a composite model, calculation groups show a very unique behavior that a good DAX developer must understand well to build sound models. In this

Back in 2020, I released the first version of the Power BI external tool to document your Power BI data model. Since then, I wrote a lot about this topic, such as why adding descriptions to everyth…

In a recent post I mused about problem domains and solution domains, how they’re context-dependent, and how interesting things tend to happen at the intersection of a problem domain and a sol…

Power BI dataflows (PBI dataflows) is a powerful data prep tool for you to transform data and reuse them in other places downstream. At the same time, while Excel is very popular among business use…

Transform the way of presenting your KPIs, understand the context behind the values within seconds, and tell your company's story.

Another Short blog on my favorite topic, High Concurrency, Low latency Interactive BI Workload, I can’t test everything, but so far, I am impressed by BigQuery BI Engine and Snowflake on Azur…

The Black Scholes formula returns the value of European put and call options. See how to calculate this with the M language in Power Query.

I'm trying to revise for the Power BI 70-778 exam by working through the reference guide. To go through the worked example I need to connect to...

Power BI Wide World Importers demo pbix provides a sample data model. Want a solution to showcase to a potential employer or to test new features?

A fictitious retail demo dataset used for presenting Microsoft Business Intelligence products.

The December 2021 Power BI Desktop update introduced a long-awaited upgrade to the partitioning and Incremental Refresh feature set. The update introduces Hybrid Tables, a new Premium feature that …

In the first post in this series I showed how the Power BI Service applies a limit on the total amount of time it takes to refresh a dataset in the Power BI Service, except when you initiate your r…

The new composite model feature in Power BI that enables datasets to be chained together using a featured called "DirectQuery for PBI Datasets and AS". Creating a data model that virtually layers existing models without duplicating effort is exciting...

Reading Time: 2 minutes If you’re a Power BI admin in charge of Premium capacity, you may rely on the Power BI Premium Capacity Utilization and Metrics template app to monitor your capacity. The current version of the app relies on a handful of...

In the first post in this series I showed how any Power BI dataset refresh started via the Power BI portal or API is limited to 2 hours in Shared capacity and 5 hours in Premium capacity, and how y…

With the December 2021 version of Power BI Desktop, as well as authoring reports in the Power BI Service, we can now add Sparklines to our Table and Matrix visuals. With just a few clicks you can make visuals that look like this:

Simulate a slow data source - making refresh slow - in Power BI

Back in June[1] the guys in cubes at Guy in a Cube were joined by Daniel Otykier and Marco Russo for a live stream on YouTube. Daniel is the creator of Tabular Editor, a powerful tool for developin…

To successfully implement managed self-service business intelligence at any non-trivial scale, you need data governance. To build and nurture a successful data culture, data governance is an essent…

We are excited to announce support for Hybrid Tables and Incremental refresh with real-time data in Power BI Premium to strike the right balance between query performance and data freshness. Now you can have blazing fast performance in import mode and the latest data changes in the data warehouse reflected in user reports without having to perform a dataset refresh.

Quickly hydrate your large models in Power BI Premium & Pro with on-demand loading!

Import mode and DirectQuery within the same table??? Yes, with the latest Hybrid tables features in Power BI, it's possible to get the best from the both worlds!

In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution).