Forum Discussion
Restrict group or certain users to pull the data from dataverse (D365) to power BI desktop
How can we allow only certain users to pull the data from dataverse connection, there is drawback we can not control who can pull the data from dataverse,
We can disable TDS endpoint that restrict all the users that is not ideal we want to allow admins.
Security Role - which is not the option as i want to allow users to access data from dynamics 365.
Suggest any alternative solution
3 Replies
Hi Anonymous
With Dynamics 365 you can use Row Level Security to secure the data.
This restricts the data Power BI users can see on a Report by login name. So you can create one report, share it with 10 other users and they will only see the data that is applicable to them.
Each user requires a Power BI licence, this needs to be Pro or Premium Per user if you only have a Pro or Premium Per User licence. It can be a Free licence if your organisation has a "Premium Capacity" licence.
You can find specific instructions on using RLS with Dynamics 365 here:
Power BI RLS report for Dynamics 365 – CRM Keeper
You can find the microsoft documentation on RLS here Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
other useful links are here (53) What is Row-Level Security (RLS) in Power BI??? - YouTube
Hope this helps
Stuart
This has now changed and you can enable TDS at user level:
Control access of the TDS endpoint - Power Platform | Microsoft Learn
