AXForum  
Вернуться   AXForum > Microsoft Dynamics CRM > Dynamics CRM: Blogs
CRM
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 16.07.2018, 21:13   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
powerobjects: Row-Level Security in Power BI with Dynamics 365
Источник: https://www.powerobjects.com/2018/07...-dynamics-365/
==============


Power BI offers a suite of security features to help restrict data. One way to do this is with Row-level security. Row-level security (RLS) with the Power BI Desktop can be used to restrict data access for specific users, filtering data at the row level, and defining filters within roles.

In today’s blog, we’ll go over how to set-up this feature in Power BI and an example of how you can use it in Dynamics 365.

What you will need:
  • Power BI Desktop
  • Dynamics 365 Organization linked with Power BI Service
In this example, we’re going to be using an Excel file composed of 10,000 fictional Orders, across multiple companies, located on the West and East Coasts. Our goal is to have a single Dashboard viewable within Dynamics 365 that displays the records appropriate per role.

Our starting point will be the image below, all orders put into a simple Orders Dashboard.



Defining Roles within Power BI Desktop

1. Select the Modeling tab.

2. Select Manage Roles.



3. Select Create.

4. Provide a name for the role.

5. Select the table to apply a DAX expression.

6. Enter the DAX expressions. This expression should return a true or false.



7. Select Save.

Viewing a Role within Power BI Desktop

Once your role has been created, you can view the results of the role by executing the following steps:

1. From the Modeling tab, select View as Roles.



2. The View as Roles dialog allows you to change the view of what you are seeing for that specific user or role.



3. Select the role you created and then select OK to apply that role to what you are viewing. The reports will only render the data relevant for that role.



Compared to the image we saw earlier; the difference is clear:



We are now ready to assign the role to a new user.

Assigning Roles in Power BI

1. Navigate to the Power BI service.

2. Go to DATASETS and click on the ellipses to the right of the name.

3. Click on SECURITY.



4. Enter the name of the user or group you want to apply Row-level security to.



5. Click Add.

6. Click Save.

Now that we have a working Power BI Dashboard with Row-level Security applied, let’s look at how it renders in Dynamics 365.

1. From the Dashboard, add a new Power BI Dashboard and select the Dashboard you published to the Power BI service.

Note: if you are not presented with the option to create a new Power BI dashboard within Dynamics, you may need to enable Power BI on the Reporting tab in System Settings.



2. Share the Dashboard with any user or team who will need access.



That’s it! Maximizing the report in CRM as Power BI and CRM administrators, you’ll be able to view the Dashboard with the entire data set.



If you sign in as a Standard User and view the same Dashboard, we get different results from Row-level security in Power BI. From this screen, we can also leverage Power BI to dig into the data appropriate to their role.



Row-level security in Power BI gives you the ability to restrict data at the row level based on true or false statements for users or groups. Leveraging the compatibility of Dynamics 365 with Power BI, we can use Row-level security to show users within CRM only the rows appropriate to their role.

You can achieve the same results by putting your data into CRM and using CRM Security Roles, however, here are a few reasons you might want to use this method instead:
  • Not wanting to store data in Dynamics 365 due to storage space or business decisions.
  • Needing to manage one Dashboard instead of multiple ones per user/ team within Power BI.
  • Business doesn’t want to run an integration between the data warehouse and Dynamics 365.
  • Not wanting to modify existing security roles or business unit security in Dynamics 365.
In the situations above, Row-level security with Power BI offers us an option to present the clearest information with reduced administrative overhead to Dynamics 365 Administrators. To learn more about Power BI, check out our Power BI Showcase.

Happy D365’ing!



Источник: https://www.powerobjects.com/2018/07...-dynamics-365/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
powerobjects: What is the Learning Path for Dynamics 365? Blog bot Dynamics CRM: Blogs 0 10.04.2018 01:27
powerobjects: Configuring the Dynamics 365 App for Outlook Blog bot Dynamics CRM: Blogs 0 08.11.2017 01:12
stoneridgesoftware: Dynamics 365 Warehouse Power BI Aligns Your Business with the New Definition of Supply Chain Management Blog bot DAX Blogs 0 04.11.2017 01:13
crminthefield: Podcast and Overview: Microsoft Dynamics CRM 2011 Update Rollup 13 Blog bot Dynamics CRM: Blogs 0 27.03.2013 22:12
dynamicsaxbi: Better together: Microsoft Dynamics AX 2012 R2 and SQL Server Power View Blog bot DAX Blogs 0 12.12.2012 13:11
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 11:26.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.