Power BI

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).

Learn when and how to best use themes to create consistency in all your Power BI reports. Join us for the discussion.

Welcome to the December 2021 update, can you believe that it’s winter and the last month of 2021 year already? We are closing out the year with great new features, such as a new Sparklines preview feature, several new Format Pane updates, e-mail subscription access via Admin API and myriad of other useful features. Please continue to read on.

If your like me, you may have gotten a little over enthusiastic about calculation groups and dropped a number of them into a report page only to find that while dense with information, the report p…

If you spend a lot of time with Power BI, keeping up with what’s new and what’s coming is really important. The release plan is the product team’s official roadmap that’s published publicly . The release plan includes new features and enhancements that the product team is comfortable putting an

There are some really interesting things on the Power BI release plan. I'd like to call out a few of the top things that I’m most excited about. In this post, I’m focusing on a few release plan items that I think Power BI administrators in particular should be aware of as we head into 2022.