Power BI

We continue to iteratively improve experiences that help you find relevant content and return to your work in the Power BI service. Upon hearing your feedback, conducting usability tests, and running …

So today Chris Finlan said a joke that I was posting a lot of positive things about my life as a PM, and so in this post I will explore a recent failure that I had in my career and what I learned. …

Aggregations are one of the most powerful features in Power BI! Learn how to leverage this feature to improve the performance of your Power BI solution!

Today’s my team and me had the opportunity to meet with one of our customers who had some features that they would like to be prioritized by Power BI. I wanted to spend some time today to tal…

Choose your favorite colors and get your Material Design palette generated and downloadable.

Learn how to design groundbreaking data visualizations and data products that people can’t live without.

Over the last few weeks we have been working on a Dataflow extension for our Power BI templates. The idea is to extract the existing queries from the

Do you know this message? "This file can't be downloaded yet. You can't download this file right now because it's been modified using an XMLA endpoint."

In this post, we will take a step by step approach to simplify a report with 6 pages + 12 measures into 1 page report + 1 measure. After optimising the report, we will explore a change that will …

Building a Dynamic KPI card with Calculation Groups allows to modify the base measure as well as the transformations to use for comparison.

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

Shared Datasets have been around for quite a while now. In June 2019, Microsoft announced a new feature called Shared and Certified Datasets with the mindset of supporting enterprise-grade BI within the Power BI ecosystem. In essence, the shared dataset feature allows organisations to have a single source of truth across the organisation serving many … Continue reading Thin Reports, What Are They, Why Should I Care and How Can I Create Them?

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

This blog post shows the users all the Power BI reports they have got access to, and details the steps in Power BI Desktop.

Have you ever wanted to quickly visualize your data using built-in features in Synapse Analytics Spark pool? Check how simple and easy is to do that!

Learn the top five most common mistakes in Power BI development and how to avoid them to have a better Power BI solution.

This content applies to: Power Query Online Power BI datasets We are excited to announce three new features for the VNet data Gateway! New capability to create VNet data gateway clusters. You can use a cluster of virtual network data gateways to load balance the queries executing on the cluster and to avoid a single […]

I was intrigued why Tableau and PowerBI have a different behavior when operating in a Direct Query Mode ( Tableau call it Live Mode), I always assumed it is just a driver difference, but it seems i…

A few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I&…

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintaine…

Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns

Case I want to refresh my Power BI Dataset as soon as my ETL process has finished. I don't want to schedule my dataset refresh x minutes/ho...

Learn the importance of enabling XMLA Read/Write

Reduce the number of measure you create by using Calculation Groups in Power BI. This blog will guide you through to get started.

This article focuses on communication tips in Microsoft teams to create a successful Power BI support channel when deploying in your org

Learn to extract any step in Power Query. How to extract any single step in Power Query. Extract a step from the middle in Power Query.

In this blog post I'm going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as the programming language because in my opinion it was a bit easier to authenticate with the Power BI service. For the development environment, I'm using

CI/CD, Branching and other DevOps concepts are very beneficial when it comes to development processes for software or in IT in general.Unfortunatelly Power BI falls short when it comes to support some of the concepts of DevOps out of the box. In this situation external tools may come to the rescue an