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…
Over the recent break, I built a basic text adventure game called Power BI Quest for Power BI’s Bookmarking Contest. You can play it on the Data Stories Gallery. It is intentional kitsch and was meant to be a quick homage to early games like Zork minus the ability to type in text and more…
In my last post, I looked at some basic considerations for font selection in Power BI. In addition, my BlueGranite colleague Meagan Longoria pointed out in a comment that you will also see the DIN font in a few cases. She has also been working a lot on accessibility lately and provided a link to…