Power BI

Recording from January 2021 Meetup: Data modeling essentials and best practices in Power BI and AS Tabular with Paul Turley

"If 80 percent of our work is data preparation, then ensuring data quality is the important work of a machine learning team." Andrew Ng Data quality is one of the highest challenges in any BI project. ETL developers tend to spend a lot of time creating data preparation processes with complex and expensive pro-code tools…

Describes incremental refresh features in Power BI

Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. However there is a hack to […]

The Power BI Summit

Fluent UI Menu Builder for Power Apps Features Icon Sets InstallationFluent UI Menu Builder for Power AppsCreate Menu Icon Collections for the PP-MainMenu Component included in the solution• Copy Image …

Easily build financial reports with line formatting, conditional formatting, subtotals and more.

Power BI toolkit including Data Lineage, Backups, Change Tracking, Auditing, Usage Analytics and Documentation, to help you keep control of Power BI

We‘re excited to announce object level security (OLS) is now generally available in Power BI Premium and Pro!

I show how using Power BI Premium per user you can do granular deployment of a new column without having to update the entire dataset.

Rolling averages (a.k.a. moving averages or running averages) over time are useful to smoothen chart lines and to make trends more evident. This article sho

Deployment pipelines helps enterprise BI teams build an efficient and reusable release process by maintaining development, test, and production environments.BI teams adopting deployment pipelines, …

Sharing reports in Power BI will be as easy and familiar as sharing in Office. At the end of this month, we’ll be introducing a new sharing capability in Power BI that will allow reports to be shared with people within the organization through shareable links.

A collection of best practice links and guidance for dataflows

We have added lots of new capabilities to Dataflows. This blog post provides a recap walkthrough of these new capabilities.

Scenario: In Power BI, when we want to process complex and unordered data, adding many steps using power query may not get the desired results. As we know, power query cannot use regular expressions. …

Here I will describe how to buy a brand new SKU, namely the Power BI Premium Per User Add-on. This SKU can be used to upgrade existing Power BI Pro licenses, either if you purchased a Pro license separately or together with an M365 E5 subscription, if you want to unlock new capabilities. The purchase is rather simple, just go to the M365 Admin portal purchase the necessary number of licenses and assign the Add-on to existing users that already have a Power BI Pro license assigned. BE AWARE (1), after upgrading an existing workspace (V2) to a Premium Per User workspace, content can be access...

After four months in public preview, we’re pleased to announce that the ability to purchase Power BI Premium on a per user basis is now generally available. 

The low-code capabilities of Power Query can be leveraged to solve highly complex data challenges. I have recently developed a data quality automation solution with it, that takes data quality to the next level. What is the point in purchasing an expensive shelf-product that implements an enterprise data quality automation suite, when you can build…

Have you ever wanted to compare a version of a Power BI file with a previous one? My new Power BI Comparer tool compares it all: Visuals, filters, RLS ...

To set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler

When I first started learning about Calculation Groups, I could certainly see how much potential this new DAX feature would eventually have. Out of the gate however, there were a limited number of …

Deployment pipelines helps enterprise BI teams build an efficient and reusable release process by maintaining development, test, and production environments.BI teams adopting deployment pipelines, …

Learn why and how to deploy Power BI for Microsoft Teams broadly within your organization. This guide provides you a game plan to justify and execute a roll-out. It helps you move to action quickly with PowerShell script example to automate the process.

As data becomes more accessible for analysis, risk of accidental oversharing or misuse of business-critical information increases. Today, we’re happy to announce a preview of Power BI MIP label inheritance when import data from Azure Synapse Analytics and Azure SQL Database. This capability will help you to ensure your data remains classified and secured across its data journey from Azure, trough Power BI and all the way to Office.

Do your Power BI users understand your report? Chances are, at least not all of it. Help them out with an information panel to help describe the report and understand all of the capabilities. Adam walks you through how to do it in Power BI Desktop!