Power BI

We are happy to announce that we have just released the May update for the On-premises data gateway (version 3000.5.185). Here are some of the things that we would like to highlight with this month…

Have you ever wondered why the Expression box in Microsoft Flow is so small? It is because Flow is a low code product and low code means that we don’t need much code. Often a one liner can do…

Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles

Recently some new options have been added to create new flows. On top of the already existing Create from template option there are now options to create an Automated, Instant or Scheduled Flow. Wh…

I was looking at my blog stats and found that some of the most popular posts are almost 10 years old (yes really). Those topics are actually still relevant so...

This blog post explains how to use DAX to solve a Power BI measure requirement where the user wanted to calculate the difference between slicers

PowerBI SmartPivot is our first product for 2019, and we couldn’t be more excited about it. If you want to learn how to use all of its features, you've come to the right place.

DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available …

The new form designer now supports authoring quick create and quick view forms. All the beneficial features of the new form designer such as WYSIWYG preview, enhanced fields pane, quick-access property pane, tree view and more now extend to quick create and quick view form authoring to help enable a rich and productive experience.

Welcome to a brand new series that I have started with with Erin Ostrowsky [Blog | Twitter] that will focus on interviewing for a Power BI position. This series will hopefully help not only for tho…

Welcome back! Today we are going back to RANKX-apalooza! We are going to add two approaches that will allow you to apply RANKX across multiple columns. I went back and recreated the examples from the original post using the AdventureWorks Database as source material and have a zip with the examples in both a .xlsx

After the dynamic titles in Power BI Desktop video, we had questions about how to do multi-select values. Patrick shows you how to do it! Demo files: https://guyinacu.be/demofiles

As Drillthrough features open the door for Power BI reports to become more interactive, it is important that they remain intuitive to use. Read on for some great DAX tips to help manage these features…

In one of my latest projects we have used PowerApps to create a location aware selection of stores – and I wanted to share my experience about how to do this. So, I found an open data set about attrac…

Last week I delivered two online sessions on the topic of integrating Power BI dataflows with an organizational Azure Data Lake Storage Gen2 storage account. I’ve blogged on this topic before…

Back in September of last year, we announced dashboard commenting in Power BI. Since then, we’ve seen thousands of you leverage this feature to collaborate with colleagues and start discussions within your organization. Today, I’m excited to announce that we are bringing the same commenting capability to Power BI reports! With report commenting, you can … Continue reading “Announcing Report Commenting for Power BI Service and Mobile”

- Bill Baer, Senior Product Manager, Microsoft Search @williambaer Introducing Microsoft Search Today, we’re announcing general availability of Microsoft Search, an intelligent, enterprise search experience from Microsoft that applies the artificial intelligence technology (AI) from Bing and deep ...

Inspired by Flow in a day, and due to demand for it in my company, I've put together content for Forms and Flow in a few hours and thought I'd share it here in case it's useful for others as well. Here's the content: Exercise 1: Create Form Task 1: Login on Microsoft Forms website and c...

I had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a similar problem…

I hear this ask quite a bit these days – I want to be able to create e-mail subscriptions with PDF (or other file format) attachments of my full Power BI report or dashboard. Well, you can ac…

I have previously written about relationships and the cardinality of the relationship. Now is a good time to explain the two types of tables we deal with every day in a reporting data model; Fact and Dimension table. In this article, I will explain what a Dimension table is, and examples of it, and how…

The following post describes ten ideas that I believe would benefit Power BI in addressing common and impactful scenarios, particularly from an enterprise BI and IT administration perspective. Each…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup136 2 Minute Tuesday: https://guyinacu.be/dynamictitles Patrick’s tech video: https://guyinacu.be/crossreportdrill Adam’s tech video: https://guyinacu.be/liveconnect Source Getting Started with Power BI Report Design level 101 – What Every New User Should Know (@Paul_Turley) POWER BI MOBILE REPORTING (@pkamasani) Grouping in Power BI Desktop Without Using […]

Do you want to change titels of your Power BI objects dynamically? It’s possible now! Read all about it in my blog post, posted from the beautiful city of Stockholm!

<p>As we open Microsoft Build 2019 this week, the Power Platform is a hot topic for software developers. That’s right: low-code has arrived as an important new capability in any professional dev…

In this post, Joao Lucindo, a Microsoft TSP hailing from Brazil shows you how to develop a Microsoft Flow Custom Connector to get audit logs from Office 365. This solution is based on the Search-UnifiedAuditLog cmdlet.

Empower your team to collaborate and make better decisions faster with our Digital Process Automation Software. No code required. Call today for a demo!

TLDR: Most quick reference guides advise you which visualization to use based on what you want people to see in the data. That’s tougher…