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…
If you have followed some of my recent posts, you may have noticed that I have focused a lot on the HTML Viewer custom visual for Power BI. As I have started using it, I have enjoyed the versatility that it brings to reports. Having HTML easily available without having to build a custom visual…
A few months ago, Power BI expanded the capabilities of Themes to include more than colors. You can now change the Format and even configure Analytics such as forecasting. In a previous post, I looked at how you can use the wildcard character (*) to universally set formatting under visualStyles. Here, I want to share…
In Part 1, you saw how to view SVG images using the HTML Viewer custom visual in Power BI. Apart from some conveniences like changing the color and resizing without losing quality, SVG may seem like a lot of work. At least, that may be true if you are only modifying one image. With a…
In my recent BlueGranite post on Bookmarks, I demonstrated how you can employ Power BI’s HTML Viewer custom visual for data-driven images. In a series of two posts on the DataVeld blog, I’ll demonstrate additional ways to use the HTML Viewer with dynamic, vector-based images: Part 1 (this post) – How to use and modify SVG…
With Bookmarks and Back functionality taking Power BI to new heights of interactivity, I employ a time-saving prefix when trying to keep various report objects straight. I add a short symbol at the beginning of the shape or image Title Text when that object contains a link. Here are the prefixes that I currently use for…