Configuring “all” access with dynamic row-level security

Row level security

Row-level security is an important part of many data models. In this article, I am showing a way to selectively grant “all” access with dynamic row-level security and only one role. For example, we can let a CEO see the whole data model, but a department head will be able to see their department’s data only. This article presents a more flexible approach in cases where using an organizational hierarchy and PATHCONTAINS would be inappropriate. Continue reading “Configuring “all” access with dynamic row-level security”

Extracting images and themes from Power BI Desktop files

Learn how to extract images and themes from your Power BI Desktop files (.pbix)

A colleague of mine has recently asked to provide him a background image from a Power BI Desktop file I have had shared with him previously. Because sometimes the original images are lost and only preserved in .pbix files, I figured a quick blog post about extracting the images would be useful. Custom themes too can be extracted in the same way. Continue reading “Extracting images and themes from Power BI Desktop files”