My organization recently utilize dataverse as a data source. We have created security roles and profiles, field security. We are happy with the "back end".
However the "front end" on Power BI, where user chooses the dataverse table is where the problem is. User are able to see all of the dataverse table even if they have not permission to load the data.
We want to remove all the standard tables and tables user do not have permission from the display option. IS THIS POSSIBLE, HOW?
Hi @JohnMarkPerez ,
You will need to build row level security in the Power BI report to control access to the data in the backend Dataverse. The normal connector to Dataverse through Power BI utilizes a single connection which will have all rights, not specific to the user. If you do want to enforce the Dataverse security then you can utilize the DirectQuery approach as mentioned here: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs...
We already have table, column and raw security in place. My problem is that a user can see all tables in Power BI even if they only have access to 4 tables. I want my user to only see the 4 tables they have access to, when they get data from dataverse.
Hi @JohnMarkPerez ,
Is this when actually building the reports or displaying the reports? In the "build" side from Power BI Desktop, the user will only be able to view records from the tables they have security for in Dataverse if the connection they are using is their own credentials. They will still see all tables in the list that I know of...
On the Power BI report side, you need to control access to the records based on the row level security as discussed or even create different reports for different users with specific tables in each report.
You might want to post in the Power BI user group and see if they have any additional thoughts.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.