Power BI

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.

Modern SharePoint is ready, and we’re here to help you get there. It’s time. It’s time to improve the performance from your intranet. It’s time to put the power of all your content, people and informa…

Last May, at SharePoint Conference 2018, we previewed new user experiences built with view formatting (previously called “row formatting”). It’s based on the column formatting feature introduced last …

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…

I was chatting to Phil Seamark (Power BI MVP and Author) recently and Phil suggested that it would be good to create a Power BI report that showed all Power BI Events around the world. The original id…

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

I have been working with a customer on the implementation of Aggregations with Composite Models in Power BI and I have found that there are a few useful tips to assist you with getting it up and ru…

There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers. When this happens, you only get half the page to visualise the actual data. But on the flip s…

This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. In DAX, variables

At Microsoft Ignite we broadly announced our vision, strategy, timeline, and investment areas for SharePoint Server 2019. Today we’re excited to announce general availability of both SharePoint Server…

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…

One of the difficulties with PowerApps is to get started. You could of course start by using one of the Application Templates. Although these may look good none of these really do what I want to do…

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

I have a choice box that allows for a users to be chosen, the display is the users Display Name. I want to set a varialbe to the selected users display name and use it in a concatenate to generate another fileds value. But the when the variable is created as a table. Now how do I extract the use...

With apologies to Theodor Geisel... Measure totals have you perturbed? Fear not! It's Measure Totals, The Final Word, These measures work with matrices, They work with tables, They work with rows and columns and labels. They work in the daytime, They work at night, They work to make sure the t...

A Data Governance Strategy defines how Data Governance initiatives are planned, defined, funded, governed and rooted in the grass roots of the enterprise. It also defines the business value needed to be realized from the outcomes on reaching specific milestones. The maturity model is a prime technique that showcases the evidence-based outcomes, if put to consistent use can assist you in the moving towards a data driven culture.

I have built several solutions over the years to enable business users to get at the data they need to do the analysis that is important to them. I would build cubes so that they could slice, dice and…

Connecting Excel do your Power BI Desktop database has many useful applications, for example you can use Excel to do some quick and advanced testing on the values of your Power BI model. Power BI D…