Power BI : April Deep Dive

Join Us for Power BI Features Deep Dive! In this session, we will have a look at the Row Level Security using Power BI and the major updates released this month along with demonstration.

1. Power BI : Deep Dive APRIL 2016 Presented By: Ankita Anchan - BI Developer Ashish Jagdale - Data Analyst Prakash Kavar - Sr. Technical Architect

2. Agenda Row Level Security (RLS) using Power BI Power BI Updates Q & A

3. RLS using SSAS Tabular Model Row level Security can be achieved using SSAS Tabular M odel in Direct Query mode of Power BI Server should be up & running RLS using SSAS Tabular Model is more Robust in performance D emonstrated Row Level Security using SSAS Tabular Model in our previous webinar https :// www.youtube.com/watch?v=lCKD9adzHC4&feature=youtu.be

4. RLS using Power BI   (New Feature) Row Level S ecurity (RLS) can be used to restrict data access for given users This is accomplished by using DAX filters at the row level Filters are implemented through roles

5. Scenario A Sales organization uses CRM data They need to provide Sales data by Role CEO of a Sales organization can view data for all the opportunities Sales Manager can view only his related sales data i.e. opportunities created by the S ales Person under his team Sales Person can view only his sales opportunities Above scenario can be achieved by using RLS in Power BI SALES PERSON

6. Limitation in RLS You can define RLS only on the datasets created using Power BI Desktop client If you make a change to your PBIX file, and republish to the service, you will need to re-create RLS Defining RLS in a group workspace is not supported You cannot add security groups or distribution lists to the member list Q&A and Cortana is not supported with RLS https ://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls /

7. Power BI Updates Featured dashboard Filter dashboard list Publish reports to a Group Space

8. ANY QUERIES? Our next Power BI webinar to be scheduled on 17 th May 2016 Contact Us - www.cloudfronts.com [email protected] [email protected]