Sign-up now and get instant access
Leave a comment
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Customized training to master new skills and grow your business.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Want to learn how to test dynamic row-level security in a Power BI Desktop file? In a previous post, I showed how to set up dynamic row level security which you can check out here.
At the end of that video, we ended up with a nice rule for imparting that security in the file. One foundation of this rule is the use of a DAX measure, either the UserPrincipalName or Username. Check out my video demo included below where I’ll walk through the testing process.
I highly recommend testing first in Power BI Desktop, before engaging in any testing in the PBI Service, because in this format the file is free of other influences (i.e. workspace permissions, security memberships, dataset permissions, etc.) that may impact what that user can see. In short, if it works in Power BI Desktop, you can be confident that you’ve got it in the right position to move it into the Service and you’ll know it’s working at its core most granular level in this file.
Look for my next post where I’ll do the same exercise in the Power BI Service. If you have any questions on row-level security, Power BI, or Azure in general, we’re here to help. Contact us or click below to speak to any of our Azure experts.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.