Power BI

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

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