Power BI

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 …

Power BI Premium Generation 2 (preview) was announced few months ago and offered substantial improvements in performance and scale to Premium subscribers. Today we are thrilled to announce that the …

At the end of 2020, I worked on a bunch of new features for SP Formatter. SP Formatter is a web extension (supports Chrome and Edge), which transforms the out-of-the-box SharePoint Column (View) Formatting experience and makes JSON editing a lot more... [Click to read more]

[vc_row][vc_column width="1/1"][vc_single_image media="88046" media_width_percent="100"][vc_column_text]Watch the video above to learn how to create a Simple Moving Average (SMA) calculation in a […]

Certification is essential for Data Analysts to increase knowledge and proficiency of using Power BI as well as to demonstrate and prove it. Getting Certified Data Analyst Certification requires a very wide and advanced set of skills and efforts.There are many sources and materials which you can use in order to prepare for this exam, here are some tips from our team.