Power BI

This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagat

In my previous post, I pointed out a lot of ways things could go wrong and the necessity to control what users of a service can do because if you don’t, be sure they will abuse every right th…

In 2020 I will be spending most of my non-work time in PowerBI instead of Tableau as I see more and more clients transitioning to PowerBI. In order to get some practice with PBI I wanted to recreat…

On this month’s Power Apps community call we have an all-star cast from the Power Apps product team joining our very own Power Apps MVP Todd Baginski to bring you the not-to be missed line up for the month covering: what is new from AI Builder, what is coming for Power Apps Portals and recent enhancements to Power Apps integration with Microsoft Teams integration.

This post and the video walk-through demonstrates how the order of steps added to a query can make a big performance difference and drastically effect the number of steps generated by the designer.

Speed up your Power BI report by showing the same amount of information in a smaller number of visuals

Adding instructions to your report enables end users to engage wth your report. This tutorial walks through various options to add end user help tips.

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. The…

The Keep all filters option creates a cache of filters every time you drillthrough from the source page to the target page.

On-premises data gateways allow users to connect online services like Power BI service, Power Automate (formerly Microsoft Flow), and Power Apps to their on-premises data sources such as SharePoint…

We asked our team for their favorite shortcuts when writing DAX in Power BI Desktop, and listed them in this DAX shortcut guide to boost your productivity.

In the coming weeks, we will be allowing customers with workspaces or apps backed by premium capacity to add users outside of the organization to e-mail subscriptions as well. This new functionality can be used whether or not you wish to add the user formally to your tenant as a B2B user, giving you the ultimate control around how you wish to share and distribute content externally.

Machine running slow with Power BI Desktop? One of these 6 things may help you out. Download Free PDF

Child flows for in Power Automate were announced late last year. This blog will highlight a few additional best practices and tips for using child flows, and if implemented will ensure that you can maximize usage for enterprise scale.

Get accurate color palettes for any word, idea or theme.

Learn about the Microsoft Sales & Returns Skateboard Report. This report embodies many great design elements, down a scrim from this report to make your own

Made with for the #PowerBI community. LinkedIn: https://www.linkedin.com/in/alexmpowers Twitter: @notaboutthecell eyJrIjoiMDkyNTRkNDMtNWRjZC00NDNkLTg5NTktYTJlYWM3OWVlZThmIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0NyIsImMiOjV9

Benford's law test in Power BI allow dynamic measures that let you cleverly compare relevant parts of your data and trigger alerts automatically.

DAX Formatter was created in 2013 to help users format their code based on the Rules for DAX Code Formatting published in October 2012. Because the main goa

This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization. The