Click on the image below to register for BlueGranite’s free webinar on Exploring Maps in Power BI. The webinar will be March 15th from 11am to Noon Eastern time. I will walk through a variety of steps to prepare and categorize your data to get the most out of your maps, survey the many visual options…
In a recent post on Tableau level of detail (LOD) expressions, I explored a method to translate FIXED to DAX in Power BI. Continuing that theme, I’ll now attempt to show an equivalent for the EXCLUDE keyword. While EXCLUDE and INCLUDE are not as common as FIXED in my experience, I’ve started down the LOD…
Back in July 2017, I experimented with interactive R HTML custom visuals in Power BI and created a simple table visual that I called R DataTable. I had originally submitted it to AppSource in October. After a few rounds of suggested changes over about four months, it is now live! That sounds like a lot…
Every once in awhile, I encounter questions from a trainee or client who is familiar with Tableau but who is getting started with Power BI. They have the ability to do X in Tableau and want to know its equivalent in Power BI. In some cases, it’s an easy answer, and in other cases, there…
In my last post, I explored a less-than-ideal way to approach the lack of object-level security in Power BI. That workaround used DAX to mask sensitive values for certain users. Since that method is not a secure one, I’ll look at an alternative that involves reshaping the data to make use of Power BI’s existing…
Object-level security is one of the significant new features introduced for SQL Server Analysis Services 2017 and Azure Analysis Services. With object-level security, you have row-level security and add the ability to lock down tables and columns so that users are unaware of their existence. Table-level security, column-level security, and row-level security can be used…
With the February Power BI Desktop and a recent companion Service update, you now have the option to add a customized collection of visuals for users. Companies may easily distribute their own or their favorite custom visuals to an entire tenant using Organizational Custom Visuals. This allows for rapid delivery of proprietary visuals without having…