Power BI Parameters, Templates & Row-Level Security
4.3 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,077 students enrolled

Power BI Parameters, Templates & Row-Level Security

Microsoft Power BI report customization using Power Query M language Parameters | G Com Solutions
New
4.3 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,077 students enrolled
Created by Grant Gamble
Last updated 5/2020
English
English [Auto-generated]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Effective use of Power BI parameters and templates
Requirements
  • Knowledge of Power BI Desktop basics
Description

Power BI Parameters, Templates & Row-Level Security by G Com Solutions is a short course designed for users who are already familiar with Power BI and are looking to extend their knowledge of Power Query, data modelling and DAX.

The course focuses on two features which allow Power BI report-creators to design solutions which enable them to quickly generate reports based on the same data model but tailored to one specific audience.

We begin by discussing the use of query parameters and templates to add power and flexibility to your report creation. You will learn how to use query parameters to control data sources and to filter data as it’s loaded into the data model.

The course then shows you how to set up and implement row-level security (RLS). You will learn how to create and test user roles in Power BI desktop and assign security groups to these roles in the Power BI service.

And we’ll also see how to leverage the DAX USERNAME function to create roles which are based on the user’s login.

The course uses the example sharing a single sales summary dashboard with a sales force and leveraging user-based row-level security to ensure that sales managers can only see data relating to their team while sales reps can only see their own figures.

So, if you’re looking to broaden your Power BI skillset, sign up for a for a free trial of Power BI Parameters, Templates & Row-Level Security by G Com Solutions.

Who this course is for:
  • Users who are already familiar with Power BI and are looking to extend their knowledge
Course content
Expand all 17 lectures 01:16:56
+ 1. Parameters and Templates
10 lectures 50:14
3. Creating dynamic titles
03:30
4. Parameterizing a filepath
04:17
5. Creating static list parameters
04:29
6. Creating dynamic list query parameters
05:42
7. Using parameters to filter data
03:50
8. Using Merge Queries for filtering
05:00
9. Exporting and using a Power BI template
12:03
10. Modifying parameters in the Power BI service
05:50
+ 2. Row-Level Security
5 lectures 25:03
2. Creating roles
02:31
3. Implementing RLS in the Power BI service
05:14
4. Linking row-level security to login
06:13
5. Implementing username RLS
05:48