Restrict group or certain users to pull the data from dataverse (D365) to power BI desktop

[Anonymous]

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

@D365PBI 

[MGrimaldi]

This has now changed and you can enable TDS at user level:

Control access of the TDS endpoint - Power Platform | Microsoft Learn

[Burningsuit]

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

[Anonymous]

Thanks for your response. 

Row level security can be applied once we pull the data from datavese, my quesion is how can we restrict only certain users can pull data from dataverse connector.