Power BI - Service

Power BI dataflows, a spectacular Power BI update

If you've ever built an enterprise data warehouse or large-scale business intelligence solution, you understand the effort that goes into building the ETL / data preparation subsystem. Tools like SQL S…

If you've come to this blog to learn more about Power BI dataflows, here are all of the posts I've published to date, in the order they're intended to be read. First of all, here is a set of resources…

By now you probably know that the Microsoft Business Applications Group (BAG) publishes its upcoming plans in its release notes online: https://docs.microsoft.com/en-us/business-applications-release-n…

One of the exciting new preview capabilities in the October 2018 release of Power BI Desktop is support for data profiling in the Power Query editor. Having per-column data profile information availab…

Now that dataflows are available in preview, you might be run into problems, and be looking for help or guidance. Please do not ask your questions here. Seriously, asking a question in comments on a b…

For the past few[1] months I've been telling people that dataflows will be available soon. They're available now[2]. Don't just take my word for it - you can also ask this guy: Or this more famous guy…

We’re excited to announce the availability of two new query histogram distribution charts. One is bucketed by query durations(ms) and the other is by query wait times(ms). Query histogram…

We are now in the last quarter of the year and, as always, the Power BI team is saving the best for last. We rolled out some of our biggest features in the months of September and October.

Paginated reports are reports that can be printed or shared. You can control the report layout exactly. They display all the data in a table, for example, even if the table spans multiple pages.

We are happy to announce on the availability of Power BI Premium Paginated Reports in Power BI Mobile apps.

In July, we first announced our plans to support SQL Server Reporting Services reports in Power BI, and later demonstrated this capability at the Microsoft Business Applications Summit. Today, we are …

We’re excited to introduce Paginated report and Dataflow metrics in Power BI Premium Capacity Metrics app (version 1.8)! The app supports monitoring the health of your premium capacities, providing…

As organizations embrace a data culture to drive business decisions, they need an enterprise business intelligence platform that can meet their sophisticated needs – from self-service BI to full enter…

Learn how dataflows work in Power BI

In the modern BI world, data preparation is considered the most difficult, expensive, and time-consuming task, estimated by experts as taking 60%-80% of the time and cost of a typical analytics projec…

We are excited to announce that we have just released the October update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release:…

It is increasingly common to include external data in business intelligence and data science. If you're working to understand retail sales patterns, you may want to include weather data, traffic data,…

One key aspect of Power BI dataflows is that they use Azure Data Lake Storage gen2 for their data storage. As mentioned in part 1, the technology is not exposed to Power BI users. If you're working in…

I hadn't planned on writing so soon about Power BI dataflows on Power BI Premium dedicated capacity but yesterday's unexpected message has forced my hand. Yes, this unexpected message. Before we look …

Part 1 of this series introduced Power BI dataflows from a largely conceptual perspective. This post is going to be much more hands-on. Let's look at what's involved with creating a dataflow in Power …

If you watched the Microsoft Ignite session recording that I called out in my last "resources" post, the pictures below will look familiar[1]. If you haven't watched it, you may want to do so now, bec…

As you may be aware, the Power BI team is working on new self-service data preparation capabilities, and after a few early name changes[1] has settled on the name "dataflows" for this new feature. Giv…

Business Intelligence, Data Governance, Mental Health, Martial Arts, and Heavy Metal.

Using a Web API is a convenient way to expose and consume data over an Internet connection. Exercising some essential design patterns, understanding and working with the Power Query Formula F…

Webinar covering Power BI advanced data prep with dataflows—a suite self-service low-code/no-code features and capabilities for business analysts to easily process and unify their data and store it in Azure-based data-lake storage.

This blog has been very silent over the past few months as all of my attention and free time was spent working with a small startup focused on delivering a commercial solution based on Power BI. I’…

Are you using Power BI incremental refresh? Have you had it not work even though you set everything up? In this video, Patrick looks at a scenario where Power BI incremental refresh was broken. He then looks at a way to get Power BI incremental refresh working properly.

Power BI Report Server was first launched in June 2017 as our on-premises server product, giving customers the ability to adopt Power BI today while preserving their flexibility to move to the Power B…

Possibly the biggest scalability feature (literally) in the history of Microsoft BI is actually here! The Power BI Desktop feature summary announced aggregations built on composite models is now suppo…