Restricting connecting to the dataverse for PowerBI

[Unicorn_Tech]

What is the best practice for an organization?

I do not want users to be able to connect to the dataverse, select an environment, and choose any table they have permissions to, and any field within that table.  I could do field level security in the environment, but is there a way to prevent them from accessing this connection anyway?

I do want them to be able to refresh a book I have made for them.

Thank you.

[Anonymous · Accepted solution]

Hi @Unicorn_Tech 

You can create conditional access policies in Microsoft Entra that restrict access to Dataverse applications based on specific criteria.

Block access by location with Microsoft Entra Conditional Access - Power Platform | Microsoft Learn

In Dataverse, you can set table permissions to control who has access to specific tables and fields. This can be done by assigning appropriate security roles to users.

Granting permission to tables in Dataverse for Microsoft Teams - Power Apps | Microsoft Learn [fac1-...

Implement DLP policies to prevent users from accessing or sharing sensitive data.

Protecting Data with Dataverse Part 2: Security from Internal Threats (Users)   - Microsoft Power Pl...

Use RLS to restrict data access at the row level, ensuring that users only see the data that is relevant to them.

By combining these methods, you can effectively control access to Dataverse while still allowing users to refresh the workbook you have created for them.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.