Power BI

One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply…

Classical incremental refresh is possible to implement for the some kind of data sources in Power BI Service with the help of dataflows.

Reading Time: 1 minute The Funnel Bar (FUBAR) Chart for Power BI is a new concept that combines the versatility and inherent trustworthiness of the bar chart with the unpredictability of Power BI’s funnel visual. Why do people use funnels? It is well-established tradition that sales reports include visuals where an axis (usually the Y axis) has bars that…

Some time ago a customer of mine (thank you, Robert Lochner) showed me a very interesting scenario where a set of Power Query queries in Power BI Desktop refreshed a lot faster with the “Enable Par…

Sometimes a requirement in a project is to have visual that represents a trend over time. Easy. Value, on the axis some time dimension values and voila! Easy as pie. Well, however, then there’…

The article that I wrote earlier this week about the shared dimension had a lot of interest, and I'm glad it helped many of you. So I thought better to write about the basics of modeling even more. In this article, I will be focusing on a scenario that you have all faced, however, took…

I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don't really need premium functions of Power BI, and only…

Several months ago, we introduced Power BI dataflows as Public Preview. Now, we’re happy to announce that Power BI dataflows are generally available! Power BI dataflows provide business analysts with a self-service data prep and management experience within Power BI, allowing them to collect business data from various sources, clean and transform it — leveraging … Continue reading “Announcing Power BI dataflows general availability”

Case Microsoft recently introduced Power BI dataflows for self-service ETL or data preparation. It uses an Azure Data Lake Storage (ADLS), ...

This is the weekly Power BI RoundUp, where there are updates to Power BI Desktop, Power BI Service, Azure Business to Business & Webinar

Weekly Power BI RoundUp which details Service and Mobile Updates, On-Premise Data Gateway, Power BI App Workspaces V2, Embedded & Multivariate

If you’ve built canvas apps using PowerApps, you’ve noticed that one of the first decisions you need to make is whether you want a layout that is tailored for a phone or for a tablet. This choice will determine the size and shape of the canvas you will work with while building your app. If … Continue reading “Craft App Height and Width expressions to create responsive canvas apps”

The team has been busy the last month shipping new features and fixes for you. You can view the weekly release information here https://aka.ms/PAWeeklyReleaseNotes . Check the release table, by region, to find out when these features and fixes will be available. Autonumber fields are now supported by the modern entity designer Makers can now create … Continue reading “March 2019 updates for Microsoft PowerApps”

How to "Predict the future" by using Power BI? Power BI, in the latest release, added support for supervised automated machine learning.This means that Power BI can help predict ‘unknowns’ once it learns from the ‘known’ values. The learning phase is called “training the model” and predicting phase ...

Dataflows in Power BI are a really interesting capability for centralizing and reusing Power Query logic among many different PBIX files. If you’ve found yourself copying M scripts (Power Query formula language) between files, or creating a library of M scripts then you should look into dataflows.

In my last post I mentioned the Power Query engine’s persistent cache, which in some scenarios caches the data read from a data source when a query is refreshed. Another important nugget of informa…

I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea why!? In this article, I will show you one…

Level: Advanced This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually. I have long been frustrated by the lack of a suitable scalable…

Level: Advanced This is the second in my series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordab…

This Power BI blog post details how to update Column names using the Power Query editor where it uses Camel Case Notation in the names

A quick post today. I received an interesting question in a webinar I did recently for “Best of Power BI World Series”. During the webinar, someone asked me “How to…

Today we presented at the 5th annual Gartner BI Bake Off session at the Gartner Data and Analytics Summit in Orlando, Florida and we are very excited to share the report with everyone. The topic this year is loneliness data from the Kaiser Family Foundation and The Economist Same as last year, a little bit of background: … Continue reading “BI Bake-Off at Gartner Data and Analytics Summit 2019”

We’re looking for business professionals who use Microsoft Power BI and/or manage Power BI accounts to join our research panel.

What is Multivariate Reporting and when is it helpful? Multivariate Reporting (also known as Small Multiples) uses a series of visuals with the same measure and same scales but showcases various partitions of the data. The benefit is that you can allow your report consumers to easily compare the same measure across dimensions and all … Continue reading “How to do multivariate reporting with Power BI”

Explore new ways to distill actionable insights from your data that drive business growth and what’s new with Power BI capabilities bundled in the April 2019 release. Join us for the Business Applications Virtual Launch Event, streaming live on April 2 from 8:00-9:30 AM PDT. This free event will showcase the new features coming in … Continue reading “See What’s Coming Next in Microsoft Power BI”

Alberto Ferrari joins Patrick to walk through how you can use DAX to format a list of values within Power BI Desktop. This takes the concatenate values quick measure to the next level. Original Quick Measure video Alberto’s article

Most of the focus on Power BI dataflows so far has been on the use of Power Query Online to load data from external data sources. However, when you create a dataflow you also have the option to att…

This article shows a DAX technique to compute the number of working days between two dates. The example includes a Sales table containing order and deliver

Makers can now create and edit Autonumber fields in the entity field designer UI. Previously this functionality was only exposed through the API, but we have now brought it to the UI for easier use. Autonumber fields are used to automatically generate unique alphanumeric identifiers for records. Makers can customize the format of these identifiers … Continue reading “Autonumber fields are now supported by the modern entity designer”