Interested in learning how to set up row level security (RLS) in Power BI when you have varied criteria? In this post I’ll walk through a scenario of setting up dynamic row level security in which your users have unique access needs. In other words, one user has access to the Northeast and Midwest regions, another has access to the Southeast, and two others overlap with access to the South and Northwest regions.
As I read the many posts from those in the community who I follow, I am reminded that the community brain trust is much greater than any individual. As a writer and blogger, I’m occasionally compelled to express an original thought or opinion that I think is uniquely my own. However, we work in a world where everything comes from somewhere and there are many contributors who I trust and rely upon for advice and cutting-edge information. This “corner” of my blog is to highlight these community contributions that I find informative.
Are you struggling to get past certain limitations while working with Direct Query in Power BI? Today, I want to share a few quick tips to help you go beyond these limitations and maximize your proficiency in this tool.
During Azure Data Week, Mike Davis showed us some of the basics on Power BI and DAX. There were many questions he was unable to answer during his session and we’re happy to share them with you now. If you missed Mike’s session or the entire week, you can still purchase access to the recordings by visiting azuredataweek.com.
DAX is an awesome language, but sometimes, DAX can produce results that are not expected. This is when DAX users can begin to struggle and get frustrated with the DAX language. In a recent webinar titled, Understanding DAX Filter Context and Incorrect Totals, our host Mitchell Pearson will walk you through why the total is not working, what’s happening with the filter context and how you can dig into that and figure out what that filter context is.
Are you looking to get an introduction to DAX and learn more about this powerful tool? In a recent webinar, hosted by Nick Lee, you will be introduced to the basics using the DAX language to create calculated columns and calculated measures. In addition to the basics, this session will introduce you to creating aggregates, conditional functions, and time intelligence calculations.
In this installment of the “Problem, Design, Solution” series, we are going to walk through the process of performing a text search using slicers in Power BI, simulating a “LIKE” type search. Please note that there is a video explaining the solution in-depth at the end of the blog under “Resources.”