Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

We’re excited to announce the Microsoft Data Insights Summit, our user conference for business analysts, is back June 12 – 13, 2017 in Seattle, WA. This two-day event is designed to help you identify deeper insights, make better sense of your data, and take action to transform your business. The conference sold out last year – and we don’t want you to miss out – so we encourage you to reserve your spot soon. 


I recently came across a particular data modeling and analysis challenge that I felt would be beneficial to generalize as I believe the basic design pattern has numerous uses. This blog post summarizes the challenge, discusses the possible uses of the design pattern and presents a simple solution as well as a more complex solution that factors in such things as row level security. A special thanks to @Vvelarde for his guidance in helping to solve the final pieces of this puzzle.


Join Blog
Interested in blogging for the community? Let us Know.