Power BI

Maintenance Window Management is a brand new capability for admins to configure App & DB update maintenance schedule at an environment level utilizing the Power Platform Admin Center.

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

Sample custom connector for ServiceNow.

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

As you take software development more seriously, Application Lifecycle Management (ALM) becomes more important.

This post describes a lightweight JIT app built on Power Platform

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

As you take software development more seriously, Application Lifecycle Management (ALM) becomes more important.

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.

It seems like it’s Azure Purview week – another feature enhancement made it to my Purview account. The enhanced metadata scanning for Power BI tenants. The Power BI integration in Azure…

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…

With the announcement earlier in this year’s Build conference, you may already heard about Power Apps Ideas, an AI-powered assistance to help anyone create apps using natural language. Now we’re excited to tell you that this feature is now officially in public preview.

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 …

Organizing items into groups makes their meaning easier to understand. I will show you how to group the items in a Power Apps gallery.

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.

Announcing the public preview for connection references support in Power Platforms Tools