service

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’…

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.

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…

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

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…

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…

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 …

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 …

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…

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,…

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:…

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…

Learn how dataflows work in Power BI

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…

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…

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 are happy to announce on the availability of Power BI Premium Paginated Reports in Power BI Mobile apps.

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

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…

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…

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…

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…

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…

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…

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…

Power BI dataflows, a spectacular Power BI update

Microsoft recently released a new feature in Power BI called “Dataflows”. You may have seen it pop up in a recent release of Power BI Desktop under Home\Get Data\Power BI Dataflows (beta) as shown…

Last week I was trying to embed a Power BI report into a SharePoint online page. I wanted users in my organization with a free license to be able to...

In this quick post you learn how to enable Dataflows in Power BI Service under a Premium Capacity.