Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

This is a very short post! A lot of people have blogged about how to convert numbers between different bases in M (see for example Maxim Zelensky’s very elegant solution for converting from binary to decimal), but today I noticed there was a very easy way to convert a decimal number to hexadecimal using the […]

Read More

Does your company plan to disable Power BI Custom Visuals, or allow only visuals from the organizational store? Do you need to detect all legacy or v1.1 obsolete custom visuals in your reports? You can run this Power BI Custom Visuals Scanner report on an input folder in which you placed all Power BI report files […]

Read More

I was looking at the list of M functions supported in custom connectors and not in Power BI Desktop (using the technique I blogged about here) in the latest version of the Power Query SDK when I came across an intriguing new function: List.ParallelInvoke(). It doesn’t seem to be documented anywhere, but I think I’ve […]

Read More

In the second article of the series Governing Custom Visuals for Power BI, we will focus on the Microsoft certification process for custom visuals, and will deduce from this process the steps you would need to take in your organization to internally certify custom visuals. But first, let’s answer some common questions: This post first […]

Read More

A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries. Each subsidiary can also have one or multiple subsidiaries beneath it.… This post first appeared at https://powerpivotpro.com/2018/09/using-dax-to-handle-multiple-parent-hierarchies/. The author is Joseph SorrentiRead More

Read More

Ever wondered how to create a heat map in PowerBI without having to use a custom visual? There is now a simple way to do this by using Conditional Formatting on a Matrix table! In my example I took some Google Analytics data showing the times of the day and amount of visitors in that […]

Read More

This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/rdJrD0uWbYI/controlling-data-access-in-azure-for-administrators-owners. The author is Melissa CoatesRead More

Read More

Recently I was working on an MDX calculation that calculated a value at a low granularity and aggregated the result – basically what I described in my blog post here. Here’s a simplified version of the calculation written on a cube built from Adventure Works data running on my local SSAS 2017 MD instance: SCOPE([Measures].[Tax […]

Read More

In this article, I will describe different approaches regarding definitions concerning BI governance. In different projects and real-world experiences implementing Corporate BI regarding deployments, environments and decisions regarding reports and panels distribution in major organizations are major considerations. Some critical… This post first appeared at https://powerpivotpro.com/2018/09/governance-in-power-bi/. The author is Gaston CruzRead More

Read More

Every month PowerBI releases new features. Some of the features are in preview mode and unless you turn it on you don’t get to use the preview features. This post explains how to turn them on. Firstly you need to have the latest version of PowerBI to get the latest features. You can download it […]

Read More

We are very excited to announce that as part of our September update, we have a preview of aggregations, which allows you to seamlessly store only summarized values in memory without having to load your entire dataset into Power BI, greatly improving the performance of your reports. This month also includes a preview of a […]

Read More

The Power BI Management cmdlets (see the announcement on this blog less than a month ago) are now available in Azure Cloud Shell. This is great news—especially for those of you who want to get… This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-management-cmdlets-in-azure-cloud-shell/. The author is Read More

Read More

How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right? Why Test? Quality testing is one of those things that few of us enjoy but is… This post first appeared at https://powerpivotpro.com/2018/09/automated-testing-using-dax-for-power-bi/. The author is Narayana WindenbergerRead More

Read More

Are you interested in shaping the future of AI in Power BI? Going to be at Microsoft Ignite in 2 weeks? We invite you to join the Power BI AI team for a brainstorming session about AI in Power BI… This post first appeared at https://powerbi.microsoft.com/en-us/blog/connect-with-the-microsoft-power-bi-ai-team-at-microsoft-ignite/. The author is Read More

Read More

At Power BI, we help you tell your story. Our platform of powerful tools empowers our users to analyze and derive insights from their data while creating stunning visuals to share that story.… This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-dashboard-comments-in-power-bi/. The author is Read More

Read More

PowerBI has this great functionality where you can go and download preset layouts which make your PowerBI reports stand out more. There is a nice trick to doing this yourself. You can create layouts in PowerPoint and then save them as images. Then insert them into your PowerBI report as an image and send the […]

Read More

It’s pretty early in the morning here in Sydney Australia (just after 6 am actually).  I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX to help write more complex formulas.  Avi streamed the session live on YouTube, and it is also there available to […]

Read More

With great pleasure and genuine appreciation, we are announcing our first community contribution to the Power BI management cmdlets. Kudos go to Kenichiro Nakamura, who joined the effort in early… This post first appeared at https://powerbi.microsoft.com/en-us/blog/celebrating-our-first-community-contribution-to-the-power-bi-management-cmdlets/. The author is Read More

Read More

I  don’t like writing reviews of books or products here on my blog for a couple of reasons, the main one being that I don’t usually have the time to read/test/understand something properly so I can write a thorough review. That said I do get sent a lot of free books and evaluation licences for […]

Read More

The owners of PowerBI.Tips and Power BI MVPs, Seth Bauer and Mike Carlo join me again share with you their ever increasing grab bag of Power Tricks, Tips and Tools they have published to http://PowerBI.Tips over the last 18 months. This post first appeared at https://powerbi.microsoft.com/en-us/blog/9-6-webinar-new-power-bi-tools-and-new-templates-including-a-walk-through-of-cool-blue-and-the-layout-purple-haze/. The author is Read More

Read More