Power BI

When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the data directly from tables, without even thinking or being aware of database views! In this article, we demystify views and explain why they should be your preferred choice when importing data from the SQL database.

This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article … Continue reading Intro to Power BI Aggregations

Today I am sharing another of those videos where I show you how I have built out my COVID report for Australia http://xbi.com.au/ca   The live report is running a few weeks ahead of my blog videos, so that is why you will see features in the live report that I [...]Read More »

Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and errors. To implement the app I needed to resolve key obstacles that are very common when you import Excel workbooks using Power Query. How do you import the data from […]

A fun way to use Power BI.   For the folks who play Fantasy Football, here is a Draft Kit to help pick the best players for your team.  By entering in your league's custom scoring rules, this report will apply those rules to the stat projections from NFL.com, and create a customized view of how the ...

Here you will find blogs related to Power BI, DAX, Power Query, VBA, Excel and much more. Power BI | Antmanbi.com

[vc_row][vc_column width="1/1"][vc_single_image media="88222" media_width_percent="100"][vc_column_text]In this Power BI tutorial, I show you how to build a quadrant chart for quadrant analysis […]

You may have noticed that a new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – whi…

This is not the first time I have shared this concept. In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some [...]

It is often the case in Power BI you need to filter your data to include or exclude rows where there are blanks. Be careful though, because you might get unexpected results. Consider this table:

In this post we'll have a look at 3 complex cases where DAX proves to be a more efficient tool than Excel.

The conclusion of the blog series looking at migrating from AAS to PPU and how it can be done in Power BI.

Learn how to easily export metadata of visuals, filters and other objects within your Power BI report.

You may have noticed that a new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – whi…

Thanks to everyone that attended the MN BI User Group meeting today. Here is a link to my slides that I presented and if you have any questions about the content please feel free to reach out here,…

The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! After months of recording and post-production wo

You can now analyze which measures and columns are used where in reports that are connected to Analysis Services models as well.

In this Power Bi tutorial, let us learned how to use Power BI Pyramid chart, and the below points:Complete SharePoint Training Course Just for $199 (Just for Today)Power Bi pyramid chart download• How …

Grouping tables in Power BI is a powerful modeling technique that allows you to select from overlapping groups either in a slicer or across a matrix.

Introduction Have you ever wanted to add a toggle feature to your Power BI Desktop Report, but don’t know how? Well the good news – it is easy to do, and even better news I will show you how to 🙂  A quick background – A toggle switch was made so users could see if […]

Here is how to calculate a moving average or sum in Power BI by using DAX. Sometimes moving average is called running or rolling average.

Here is how to detect the last available column value in Power BI in almost any situation. The problem is columns with missing values.

Here is how to create a Power BI line chart that at some point continues in a different design, formatting in few easy steps.

#APIS #CATALOG #POWER BI #POWER BI ADMIN API

Time flies when you are having fun and learning, right? Time for the 6th blog in the series of transforming a local solution into a global, enterprise-grade Power BI solution. This episode will be …

CSG ProCustom Software, Business Intelligence and Cloud ServicesBasic Power BI ReportThe Very Basics of Great Power BI Report DesignSome Power BI report design skills take years to master. These …

Here is how to create a dynamic histogram in Power BI. It changes with the help of a slicer that regulates data distribution groups (adjustable bins).Forewords about histogramA histogram is a great …

A big data visualization solution in Microsoft Power BI summarizes and tracks performance against business objectives while Microsoft Core Services Engineering and Operations drives results. This solution refines large amounts of data into accurate and actionable insights for the entire organization. It improves satisfaction, enables growth, and drives operational effectiveness on Microsoft’s road to digital transformation.