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…

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…

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

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…

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…

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

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

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.

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

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, Adam Saxton sits down with Josh Caplan to discuss how to monitor and manage Power BI Premium capacity. This includes looking at the Power BI Capacity Metrics App that has a dashboard and report for your capacity metrics. They also discuss other considerations when using dedicated capacity. This discussion also applies to […]

Calendar tables are an absolute requirement for time-intelligence calculations in Power BI. In this week's webinar Power BI MVP Tristan Malherbe will deliver a webinar on how to build a proper calendar table using Power Query and M language.

Join Charles Sterling and Josh Caplan as they answer questions from Power BI Customers on managing premium capacities. When: 10/18/18 Time: 12:00 PM PST watch?v=YLhvGQ7C2m0

Hi , See my solution attached, page 3 https://1drv.ms/u/s!As5oZCclkGkWgSUKbcIgvNE_f5Qd I have created a new column [Type] in 'Selected Throughput' and created a relationship with [Test Type] in 'Actual Data' (I have noticed one row says 1200 instead of 1000 as in your post, beware of that) I...