Is there a way to restrict access to a table via other means, such as Power BI, XRM Toolbox etc.?
I have an app that has a lot of logic to determine what users can see, based on their identity against external-imported tables, which are updated daily. I cannot release the app until I know that users can't access all of the external-imported table records, via Power BI, or other means.
The organisation has thousands of teams, so replicating that structure in terms of business units is an impossibility. Only supervisors from a department should see their staff records.
Without some form of external access restriction, I don't see how a solution like this can scale.
HI @J0el ,
There are a number of ways to secure the Dataverse table data from access by individuals that do not have the right level of security to see the information. You should focus on the data security vs the application as there are always ways that individuals can try to go after the data including APIs, Power Query, Power BI, etc.
Key concepts for securing the data:
@J0el - I have just responded to your question in your other post:
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1