Power BI

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.

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 …

[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.

See Vertipaq Analyzer stats in Tabular Editor and create Best Practice rules around them.

Want to improve the performance and design of your Power BI model? Run these newly published rules against your model to quickly identify areas of improvement!

One of the most exciting things about being a Power BI service administrator is watching what's going on inside the service. This blog starts a series of articles on how to create your own Service Monitoring application using Power BI.

There is just one thing that is more satisfying than writing complex DAX measures, and that is avoiding complex DAX due to smart data modeling.

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

Query folding is a key capability in Power Query. In short, query folding is the process by which the Power Query mashup engine takes the steps defined in the Power Query editor and translates them…

This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all