Power BI

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 times.I was working on a data model that had A LOT of …

The Query Plan visual will allow you to understand what’s happening under the hood of your query with more details than the Step Folding indicator.

The Microsoft Business Applications Summit 2021 happened recently, just a couple of weeks after the Power BI Summit, and there were a bunch of exciting announcements and updates from the Power BI team. If you missed seeing them all in one place, this article and video are a nutshell of all of those in one Read more about All Power BI Announcements of Microsoft Business Applications Summit 2021 in One Place[…]

We introduce to you the Explicit Measures Podcast. Where we discuss and have fun talking about the why we do what we do as Power BI Developers

Today we are excited to announce the initial availability of Power BI connected PivotTables in Excel for the web. As part of our journey to simplify enterprise data discovery and analysis in Excel, …

You might not see this feature yet. Some functionality is introduced gradually to organizations that have set up the Targeted release options in Microsoft 365.       Imagine you’re working on a project that needs a new SharePoint site to track deadlines, record progress, and serve as a central plac...

Today at the Microsoft Business Applications Summit, we’re showing off a big step forward for the unification of the platform. Bring the full flexibility of the Power Apps canvas – from unlimited UX control to hundreds of data sources – directly into model-driven applications as a custom page using the new App Designer.

Organizations exist to achieve business objectives and in today’s data driven world, we know that progress is measured through data. However, this is often challenging as goal tracking systems are disconnected from your business data and often require manual updates. Not only that, but goals need to be optimized for teamwork, tightly integrated into core business processes, and easily extended. We are very excited to announce the public preview of Goals in Power BI. Read more in this blog!

Microsoft Business Applications Summit is one of my favorite events of the year. While we connect with our customers, our community, and our partners every day, at the Microsoft Business Applications Summit, we share some of our most important announcements on our strategy and roadmap. We prepare and deliver some really exciting demos and our product managers and engineers look forward to answering all of your questions.

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic …

[Deprecated] This is the Microsoft assembly for the .Net 4.0 Dynamic language functionality. - zzzprojects/System.Linq.Dynamic

Have you ever had the idea of finding which measures in your model use a particular function? Or a quick view of all the calculated columns in a model? These are relatively simple tasks but it can be …

This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation. Table functions

What you can do and why you should Have you ever been facing the problem of showing small and large numbers together (e.g. 123,456, 789.99 and 34.56) in a nice way, lets say with a 3 digit precison as 34.5 and 123G (or 123E6).   When working with large numbers you can divide them with 1,000 or 1,000...

In this blog post, I will give you a comprehensive overview on the Power BI calculation groups. I’ll share with you some of my tutorials around calculation groups and you’ll see how and when to use them.    Calculation groups are a collection of items, which are basically the same measures that you ...

This article is the fourth release in a series of “pill” blog posts aimed at investigating performance issues that could affect the proper operation of the On-premises Data Gateway in Enterprise …

How to get a summary of active Issues from a Microsoft Lists/SharePoint list created using the Issue Tracker template a using Power Automate.

In this article I will show you how to force app updates in Power Apps so all users will have the same app version when you click publish.

How to measure the duration of a Power BI DirectQuery query using Performance Analyzer

.Use calculation groups in Power BI to control when measures get processed using an Apply All button

With Power BI becoming more and more popular, it can be observed that organizations are trying to move their current reporting platform in to Power BI based solutions. However, success of this migr…

Premium Gen2 Preview important dates for autoscale coming up and timelines update

DAX (Data Analysis Expressions) is the programming language of Power BI and it was created in PowerPivot for Excel back in 2010, integrated in SSAS Tabular and then, in 2015 in Power BI. There are two main types of users who are learning Power BI (and also DAX if they really want to master Power

PAFnow Sign In

Learn to change the default theme of Microsoft 365 and customize it to match your company logo or color.

The ability to filter data by user is critical whenever sensitive information is shared, whether internally to an organization or even more so externally. This is often known as “row level se…

Most people working for a single organization are unlikely to run into this use case, but if you’re a consultant like me then this issue will annoy you. In Power BI Desktop, authentication ag…

Microsoft Power BI rose to its leading position in the BI market on the back of its top-shelf PowerQuery self-service ETL and VertiPaq in-memory engine as well as its familiarity and integration fo…