Power BI Resources
-
Connecting Power BI to Databases: Import vs. DirectQuery
Gain insight into how each mode works, where the data lives, when queries run, and the trade-offs involved in choosing one over the other. You will learn why Import mode is the default and best choice for most reports, when DirectQuery is genuinely necessary, and how to connect to a SQL Server database
-
Dynamic Row-Level Security in Power BI
Learn the complete implementation process, from adding a user-territory lookup table and connecting it to the data model, to creating a dynamic role using the USERPRINCIPALNAME DAX function, to publishing and granting access in the Power BI Service.
-
Row-Level Security in Power BI: Implementing Static Roles
Follow a complete walkthrough of implementing static RLS roles, from creating the role and defining its filter rules in Power BI Desktop, to publishing the semantic model to the Power BI Service and assigning users to the role.
-
Using Parameters in Power BI for Interactive Reports
Walk through the complete process of creating a numeric parameter, adding it to a report as a slicer, and connecting it to a DAX measure using the SELECTEDVALUE function.
-
Data Modeling in Power BI: Many-to-Many Relationships and Filter Flow
Follow a hands-on example of building a sales report that tracks revenue generated within a defined window after a marketing campaign touch.
Showing 5 of 9 entries