Power BI

The date you have long waited for has finally arrived!  The public preview of Power BI Premium per user has been enabled in all public tenants that requested priority access, and will be rolling out to all tenants worldwide throughout the month of November.  Now, Power BI users have access to all the Power BI Premium capabilities, on a per user basis, for the entire trial period for free. 

 Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis.  With just a couple of clicks, you can easily find insights without slicing and dicing the data.

This post is an overview of ‘Visual Data Prep’ (Diagram View) which is going into Public Preview.

Calculating and visualizing semi- and non-additive measures like distinct count in Power BI is usually not a big deal. However, things can become challenging if your data volume grows and exceeds the …

Level: Intermediate. One of the commercial services I offer is to complete a health check of Power BI deployments. I look at everything including the data model, the DAX, the queries, the distribution approach, and other things to help you polish your work. I thought I would share with you [...]

The default way to retrieve files from a SharePoint folder is slow and getting a single file cumbersome. See functions that improve import from Sharepoint.

Originally posted on PowerBI.tips: https://powerbi.tips/2020/01/power-bi-field-finder/. If you haven’t yet, be sure to check out PowerBI.tips for all kinds of wonderful Power BI content!Download (and …

Our anomaly detection algorithm detects that there is an anomaly this month: Anomaly Detection is in preview! Also, we are announcing a preview of the new Field List and the Model View. We are adding a fan-favorite: the Visual Zoom Slider! In the Service, endorsements for datasets and dataflows are extended to reports and apps, enabling business users to be confident they are making decisions based on the right data. Read on to explore and discover more in this month’s update.

DAX Power BI Visual Studio Code External Tool

All the improvements of the ‘new look’, from navigation updates to the simplified action bar for reports and dashboards, begins rolling out next week and will be generally available to all tenants and users by early November. Thank you for your feedback during public preview as we made incremental updates to modernize and simplify the Power BI service.

Power BI CoE is an important concept if it is understood that Power BI implementation does not end when the platform is open and available to your organisation.Implementation starts at this …

Drill through from cards is a common requirement in Power BI reports. In this blog post, I'm showing two ways to configure it.

Moving important business data into a data model for analytic reporting can often be a two-edge sword. Data retrieval is fast and can support all kinds of analytic trending and comparisons. But, da…

I’m always looking for more productive ways to work with Power BI and associated tools. As I covered in my article last week, development of Power BI reports using SharePoint for your file storage can be so slow that it is impractical. In this article I discuss the various options [...]Read More »

Waterfall charts provide a great way for users to visualise how pieces of an overall plan (or results) are combined to contribute to an outcome. For example, you could use a waterfall chart to show how sales have increased by year and category as illustrated below using the standard waterfall [...]Read More »

The last post and video in this series looked at the broad topic of training. This post looks at as specific aspect of this topic: letting people know what is possible, and sparking their imaginati…

Last week’s post on migrating to Power BI was intended to be a stand-alone post, but this excellent comment from Matthew Choo via LinkedIn made me realize I had more to say. I could not agree…

In an ideal world, everyone knows where to find the resources and tools they need to be successful. We don’t live in that world. I’m not even sure we can see that world from here. But i…

Power BI lets business users solve more and more problems without requiring deep BI and data expertise. This is what self-service business intelligence is all about, as we saw when we looked at a b…

At Microsoft Ignite, there were two really exciting announcements when it comes to enterprise features for Power BI. Both directly took my attention, as well as for many others. Obviously, the firs…

Did you know you can retrieve some header data with Power Query that your web call returned? Check out how the function Value.Metadata does this for you.

This article describes the behavior of the DAX functions that manipulate sets; they are useful to create queries and sometimes also to author measures. In t

One of the great news in Microsoft Ignite 2020 is the announcement of a new licensing plan for Microsoft Power BI, called Premium Per User, or Premium Gen2. In this article, I'll explain what that is, and how this can be helpful for Power BI users. Power BI Licensing To understand the Premium Per User…

Data source management in admin center

October release of gateway

Most of the time I’ve spent looking at Power Query Query Diagnostics data, I’ve been looking at data for a single query. Over the past few days though I’ve spent some time investi…

What would an epic battle be without champions? Lost. The epic battle would be lost without champions. Don’t let this happen to you battle to build a data culture. Instead, find your champion…

Have you ever heard the term “Excel hell”? Odds are, if you’re reading this blog you’ve heard it, and possibly lived it once or twice. If not, you may want to take a minute …

Working with a Golden Dataset in Power BI is considered as a best practice. But how to proceed if you decide to split up dataset and reports later?