Power BI

Want to use a custom font within Power BI Desktop, but don’t see a way to do it? Here’s a trick to use that custom font. Download Sample Theme

<p>Use Datset owner’s UPN for Refresh-based Reports</p>

<p>We’re excited to announce the release of Power BI APIs .NET SDK v3.<br /> The new version is easier to use, have additional capabilities including the new credentials classes and easier way to encrypt credentials.</p>

Learn how to determine if your revenue growth is good by checking if your margins expanded using Power BI measure branching.

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI.

Calculate net working days like in Excel with my new Date.Networkdays function for Power Query. For holidays, simply refefrence column of a calendar table

Test your JavaScript, CSS, HTML or CoffeeScript online with JSFiddle code editor.

Make sure you’re making intentional visual choices

<p>We are pleased to announce that, in addition to incremental refresh reaching general availability, it is also now available with Power BI Pro licensing.</p>

Reading Time: 3 minutes I don’t usually comment on the Gartner Magic Quadrant for Analytics & BI other than to congratulate vendor teams on their work, but I would like to encourage people to at least skim the report. Reprints are available free from many of the vendors. Why bring this up? I’ve seen a few misleading comments about…

And here's a link to "The Human Impact of Data Literacy" report that's mentioned in the above article: https://t.co/xeFCOiNM1t— Melissa Coates (@SQLChick) February 19, 2020

<p>We are super excited for our update this month! We are releasing two of our top community requests: incremental refresh for Pro and hierarchical slicer. Additionally, we’ve added some improvements to the new ribbon and a couple new DAX functions. Since our last release, there have been several new custom visuals released on AppSource, so be sure to try them out! If you want to learn about all the updates and enhancements this month, check out the full blog.</p>

Announcing General Availability (GA) of Bring Your Own encryption Keys (BYOK) for 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…

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…

If you are a Business Intelligence consultant working in Power Platform, Azure Logic Apps and Azure Analysis Services landscape, you probably felt that On-premises Data Gateway is one of the essential parts of your engagements with the your customers. Installing On-premises Data Gateway can go smoothly if you already have a well thought implementation plan … Continue reading Definitive Guide to Implement On-premises Data Gateway (Enterprise Mode) in Organisations

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.