Power BI

I explained what SCD means in a Business Intelligence solution in my previous post. We also discussed that while we do not expect to handle SCD2 in a Power BI implementation, we can handle scenarios similar to SCD1. In this post, I explain how to do so. Scenario We have a retail company selling products. … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1

How to show almost 200 countries data on a treemap visual? For this experiment I took international trade statistics (merchandise exports by product group, annual) … Read More

Hear about the latest updates to Datamart in Power BI since the //Build announcement

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing an AAS database. The flow referenced an Excel file with the infor…

In the July 2022 Power BI update, they updated the Dataverse connector. The connector now uses the display names from a Dataverse table.

We’re thrilled to announce that a new component for embedding Power BI content in Vue.js applications is now available! Vue is an increasingly popular JavaScript framework for building front-end user interfaces and websites.

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing a Power BI dataset. The flow referenced an Excel file with the in…

Explore what data clean rooms are, why they're important, and how your organization can implement them in Snowflake - all in this blog!

We are very pleased to announce the introduction of AAD-based filtration to the Power BI Datamarts tenant setting.

Explore 8 essential steps that will help healthcare organizations plan and build a foundation for an actionable data strategy framework.

The first post after my vacation. I was in doubt for a while whether I should write this one or not… given the preview state. Since one of the customers I work for asked me for advise today a…

Yesterday I was facing an annoying issue. I have two Power BI datasets. Both connect to the same Azure SQL database, but with different SQL users (they have both different permissions on the data in the database). This can be a use case for example where you have data for multiple clients inside one

Welcome to the September 2022 update. We are thrilled to announce a variety of new features such as hierarchical axis by default, translations for composite models, mobile formatting options general availability and cross tenants’ datasets sharing. There is more to explore, please continue to read on.

Using the new Power BI Audiences with AAD Security Groups for easier management of reports/dashboards for users.

I came across this Global Views on Abortion Report which showed the following graph: It was great to compare support for permitting abortion across different countries, but it was a little more difficult to compare support for not permitting abortion across countries. So I thought I’d have a go at modifying the chart slightly. From… Continue reading Quick Chart Makeover

In this post I will go over a topic that is frequently asked about and that is using a Service Principal account with Power BI when connecting to data sources. Currently today none of the built-in …

The Power Platform Landing Zone is the beginning of the path to overcoming these barriers. A foundation, if you will, the Landing Zone is the initial technical infrastructure plus governance of that infrastructure that allows an organization to begin “landing” workloads in Power Platform. With that

Learning to consume APIs in Power BI has been a game-changer for me. As I started making my first API requests, a world of…

In this article, we explore Power BI App Audiences and why they are such a powerful feature for managing and using content in Power BI Apps.

DataOps Principle #10: Orchestration

If you are a Power BI report developer, you might have experienced the case I’m describing in this post. You did your utmost best to setup a decent DT(A)P process, where you clearly separate …

One approach to optimise DAX queries is to focus on the number of Storage Engine (SE) calls generated by a query and look for ways to provide the same result using fewer SE calls. If a query takes 30 seconds to run and makes hundreds of SE calls, reducing the number of SE calls almost … Continue reading DAX 1-Column Fusion

What if I tell there is a way to show only the desired data labels in PowerBI and that is without any extra visuals? It can be applied to almost all the visuals I tried, just need to write DAX. There are two tricks I have used here the first trick I came across was by luck, and I am not sure if anyo

The Ultimate EPL Fantasy Football Report!

Connecting Power BI to Microsoft GraphYou are almost near to achieve your goal of becoming Microsoft Power Platform expert. Till now we expect that you have read all the previous blogs and this is our fifth blog. Let have a top-level view of previous blogs.Revision:In first blog we have learned the b

Microsoft Power BI is a business analytics tool which allows users to gain insight from their data. You can easily create an interactive dashboard by just dragging and dropping data columns into the visualization plane. In this article, I'll show you how to use Python to help you leverage

StrataScratch is a data science interview platform that has over 1000+ real interview questions from top tech companies like Facebook, Amazon, Google, and more.

Today, we are excited to announce the public preview of Multiple Audiences in the Power BI Apps, one of the highly requested features from the community. With multiple audiences for an App, now Power BI App author can create multiple audience groups within the same App and assign different permissions to each group.

DAX Studio 3 has been released today. This new major version has a new user interface and user experience, providing a modern look and feel without losing a