Power BI

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!

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 …

Object-Level security exists for a while in some Microsoft's products. But, this is a brand new feature in Power BI! Still in preview, so let's put it in the spotlight and check all its Pros and Cons

Sometimes you want to reduce data in Power BI Desktop so it’s easier to work with. Then work with all the data in the Power BI Service. Patrick shows you 3 ways that can help do this without using Incremental Refresh or needing Power BI Premium!

Customise, adjust and download free vector icons. Ikonate is an adaptable set of optimised, accessible SVG icons that use can easily use in both development and design apps such as Sketch and Photoshop. Ready to use as images, inline SVGs or SVG sprites.

IconPark, park your icon. Made by ByteDance

Feather is a collection of simply beautiful open source icons. Each icon is designed on a 24x24 grid with an emphasis on simplicity, consistency and readability.

Remix Icon is a set of open source neutral style system symbols elaborately crafted for designers and developers. All of the icons are free to use for both personal and commercial.

In my ETL workflow, there are always larger text/CSV files, error files to view or one-time files I need to modify. The biggest feature I need is to page through large files as some will not fit into memory. I found a great CSV editor that I think will fit your data workflow also.

This blog post demonstrates how to feature a certified app in Power BI Home and in a Users Apps to be easily found.

Make sure you get notified when the Microsoft Power Platform user groups go live for public preview.

As you may have noticed, life is complicated and keeps getting in the way of my plans to be a more active blogger and YouTuber[1]. I haven’t released a new dataflows video of my own in far to…

Today’s post builds on top of Power BI Admin Scripts Part I by describing five additional PowerShell scripts that Power BI service administrators can utilize to address relatively common scen…

On-premises data gateway (standard and personal mode) release for March 2021

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