Power BI

In Part 1 of this blog series I introduced the fundamental concepts of Power BI embedding and explained the difference between first-part embedding (the user-owns-data model) and third-party embedding (app-owns-data model). In this blog we will begin by examining Power BI Premium capacities and, aft...

In this video, Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh. MEQM Files – https://github.com/guyinacube/demo-files/tree/master/video%20demos/MEQM

For me, a good data warehouse enables business pros to create reports without needing to think too much about the data model. Another benefit I see is the ability to deliver operational reports from transactional databases (ERP, CRM, financial systems). 5 Suggestions for aligning a data warehouse with Power BI.

Custom visuals bring great value to your organization. By using tailor-made visuals, enterprises can tell their own story and visualize data in the best way! In some organizations custom visuals are even more important – they might be necessary to convey specific data or insights unique to the organization, they may have special data requirements, or they may highlight private business methods. Such organizations need to develop their own custom visuals, using the Power BI opensource custom visuals framework. Or find a consultancy service offered by one of our partners. Where organization...

Welcome to another week of the weekly Power BI RoundUp, I hope you enjoy catching up on the latest content below. Power BI – Power BI Preview Features in Action In this blog post by Chuck (Charles)…

It is very difficult for an organisation to decide whether to buy Power BI Premium or to stick with Power BI Pro. Power BI Premium represents a big financial commitment, but how do you know whether…

On October 25th, 1997, I attended a football (American) game in Lawrence, Kansas between the number 1 ranked Nebraska Cornhuskers and the Kansas Jayhawks. It was a cold and rainy night which, in addit…

Power BI MVP and crowd Favorite Avi Singh will be presenting: Building Impactful Financial Dashboards Using Microsoft Power BI Webinar 10/16

I recently was troubleshooting a performance issue for a customer where their LiveConnection was slow when connecting to an On-Premise SSAS Tabular server via the On-Premise Data Gateway. One of th…

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…

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…

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.

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…