Power BI

Have you ever looked at a problem and immediately known how to solve it? Have you ever seen that there’s already a group of people who are responsible for solving this problem this problem, a…

We'll work through some advanced analytics examples for Power BI during this particular article. Firstly, I want to show you how you can discover and showcase clusters in your datasets. To be able to do this in Power BI, we need to combine some modelling techniques and formula ideas that will ena...

After reading Gil’s article asking if we were “Riding the wave of Power BI”, I wondered what we’d share about our own journey. Now down the road from our humble beginnings in Power Pivot, we’ve put pen to paper to share our experience. Six years ago, I had a hard time believing that Excel would …

I was recently tasked with revamping the Microsoft 365 Usage Analytics template app, as it was created several years ago and could benefit from many of the new features in Power BI. When I initiall…

The blog post demonstratesstore the Power BI Audit Logs using Azure Function Apps and Azure Blog Storage to store the files.

No matter if you are a business user, analyst or data scientist, Power BI has AI capabilities tailored to you. In this session we will cover how you can integrate and leverage these capabilities. Come to this session to learn how you can enrich your very own Business Intelligence with Artificial Intelligence and make the step up from Power BI to AI.

With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created to display and update real-tim…

Gateway Performance Monitoring is a frequently overlooked but important part of Power BI governance. Review technical considerations for implementation.

<p>Feb 2020 gateway release</p>

Working with APIs in Power BI? This article provides some suggestions on how to work efficiently with API calls in Power BI.

<p>This blog post covers the latest updates for Power BI embedded analytics and Power BI visuals platform</p>

In this video, Manu and Paul provide details on various support scenarios and options for Power BI. This series provides a structured approach for developing...

Reading Time: 2 minutes Many organizations deploying Power BI rely on one or more standardized template (.PBIT) files. Especially when paired with a custom theme, templates help create consistency for branding or other reasons. Perhaps you want to open the same PBIT (or PBIX) every time you open Power BI and don’t want to rely on finding and opening…

Benford's law test in Power BI allow dynamic measures that let you cleverly compare relevant parts of your data and trigger alerts automatically.

Natural language query was probably the most unused feature in Power BI, until they introduced the new Q&A visual in the end of 2019. I’m a huge fan of this feature, but it is sometimes a…

Send Power BI alerts to users via Teams using Power Automate and format the data using Adaptive Cards

Last week’s post showed an M function that took Power Query diagnostics data and formatted in a way that made it suitable for visualisation in a Power BI Decomposition Tree visual. This is gr…

More than a year ago, a question was asked on the Power BI community in regards to showing a heat map in Power BI. Not just a simple heat map in the matrix visual, but a heat map based on data smoo…

A few months ago, a very interesting question was posted on the Power BI community forum and I had the opportunity to work on it. Finally, I have the time to write a blog post about this so that we…

The change to the Publish to web default experience announced in 2019 will start rolling out this week. It requires Power BI admins to take action before users can create new publish to web embed codes. This blog help you understand what users can expect and what actions admins should take as the change rolls out.

Power BI Seed every BI engineer needs to build out consistent great navigation in Power BI

I came across an interesting request last week from someone who wanted to dynamically control columns shown in a Power BI table visual – based on the values within each table. There are lots …

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter)…

Here is another interesting use case of Row Level Security (RLS). It’s funny that my first post was also about RLS – when you use RLS, lot of different challenges show up (which are not…

Technical articles, content and resources for IT Professionals working in Microsoft technologies