With the December 2020 release of Power BI Desktop we got an early christmas present. A loooong waited feature that will change how we build Power BI solutions! The feature is called “DirectQuery for Power BI datasets and Azure Analysis Services” also known as Composite Models Gen2.
It is easy to use Power BI as a self-service tool. However, using it in a multi-developer environment comes with challenges. You can easily end up with silos of Power BI solutions, duplicates of Power Query, and DAX codes. Come to this session to learn how to avoid duplicate work using the right architecture for developing your Power BI solution. Session Level: Intermediate
A well thought out Power BI data model can make creating a well functioning report a breeze. Relationships form the core of any model, but what if the relationships you have won't allow the calculations you want? Do you want dimension tables to filter each other? Should a fact table filter a dimension? By getting creative with your DAX measures, it is possible to do this and more, while still keeping the model functional. This session will introduce and explain several DAX functions for manipulating relationships including CROSSFILTER, USERELATIONSHIP, and TREATAS. Session Level: Intermediate
Power BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations and features can be created a number of ways including: layering visuals, customizing visual formatting, and/or utilizing DAX measures. The session will include a series of visualization and reporting techniques that you'll be able to leverage in your company's reports to take them to the next level. Session Level: Intermediate