Power BI

In the past two years, I released 5 Power BI apps on AppSource. You can take a look here. To celebrate the milestone of releasing the latest ActiveCampaign app and for reaching 20K unique installers across all apps (with ~150 daily new users), I am going to email you a special gift: A Power BI…

Join the Microsoft 365 Champion program to get access to free training, experts and resources to build your skills and drive adoption.

“Don’t repeat yourself” is a software development principle all great app makers follow. In a practical sense, it means any repetitive code should only be written once as a custom function. Then the …

Enjoy two new experimental features for formula based components. Behavior properties enable a component to fire a custom event into its container, such as OnChange. Property parameters enable the passing of arguments for a property evaluation, providing our first steps toward formula based user defined functions.

In this video, we look at Power BI for report consumers, or end users. Those folks that maybe don’t author reports, but just view reports within Power BI. We introduce some basic Power BI concepts and introduce you to areas of the Power BI service to get you familiar with the portal. Documentation: https://docs.microsoft.com/power-bi/consumer/

Have you ever tried to use your browser to zoom in on a visual in a Power BI report? If you simply published your report and then zoomed in, you might have experienced something like the video belo…

This articles looks at Power BI architecture in a data solution and different roles and responsibilities involved to expand Power BI skills.

In this blog post, we are going to dive into the world of averages and how to solve problems when calculating averages by using CALCULATE, SUMMARIZE and AVERAGEX. Specifically, we look at creating …

I have to warn you, this is NOT a level 100 or even 200 tutorial. If you decided to proceed, that you absolutely positively have to get that progressive calculation work and I will have to assume t…

If you are looking to change the user connection when using Excel to a Power BI dataset or Azure Analysis Services I explain how to do this.

Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more

Progress update for Jan 2021 on “Deneb”, including some new changes that are moving towards improving integration with Power BI.

It’s T-SQL Tuesday!! After making my first contribution to T-SQL Tuesday last month, I figured I couldn’t stay behind when it’s a topic I have loads to share on. T-SQL Tuesday is the brainchild of Adam Machanic (Blog | Twitter). December 2009 was the first T-SQL Tuesday invitation that went out by Adam. It is a monthly […]

Some interesting new Power Query functionality was released in the December release of Power BI Desktop (it’s also in the build of Excel I’m running) that didn’t get announced in …