Power BI

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

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.

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

In recent years, mental health of professionals has become an increasing concern. Here, I share a 5-step approach to use mindfulness to combat disruptive thoughts & feelings and improve mental wellbeing.

Vertipaq is the actual database engine used in Power BI. It is also the engine used in Analysis Services Tabular and Excel Power Pivot.One of the reasons behind Vertipaq’s great performance is due to the different compression techniques that it applies to the data. The overall purpose of the different compression techniques used is to […]

Contribute to samaguire/TabularEditor3Scripts development by creating an account on GitHub.

Learn how Microsoft successfully drives a data culture for business decision making. It describes their strategy and vision for BI.

Being able to do a data driven report subscription with Power BI and Paginated reports is a common request we hear from many customers. Let’s say you want to send a PDF version of a report to…

This is the second article in a series on the introduction to the EvaluateAndLog function. As I explained last time, EvaluateAndLog can be used to print to the debug output the intermediate result …

Reproducing Robert Mundigl’s variations on bullet charts using Deneb and Vega-Lite.

If you’ve read part 1 or part 2 of this series you’ll know how you can create a Power Automate custom connector to call the Power BI Enhanced Refresh API and get fine-grained control ov…

Do you want to return the next working day in Power Query? There is no build in M-function for this, but this post shows how to create one yourself!

Introduction A key requirement for strong Power BI governance is being able to easily report on usage from logs. There are many ways of getting logs in Power BI and many blogs looking at the variou…

When I'm developing reports, I'm asked multiple times to "hide" the slicers/filters from the report page. Usually this is to make space in the page for other visuals and because customers don't want to use the filter pane for some reason. This happened so many times, and only in the last couple of months I decided to try some things out and get a bit creative with Power BI. I came up with two solutions, which I think work great in these scenarios. Remarks: - This might not working very well if y

In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the…

Building a Custom Power BI Visual from scratch (KPI Card) In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the dashboard), drill-through functionality, formatting options and highlighting. The code changes are kept to a m...

It started with @shan_gsd‘s tweet about Year 2022 Week 33 of the Workout Wednesday and @CJMajka‘s reply “A dumbbell chart in #PowerBI?! That is kind … Read More

I spend a lot of time going through the Power BI documentation to find answers about Power BI features. As always, I look for opportunities to make my life easier when I need to look through of data. What better tool for this than Power BI itself? So, I created a few reports to help

A key feature to optimize your #powerbi dataset refresh is to partition your dataset tables, this will allow a faster & reliable refresh of new data simply because with partitions you can divide the …