Unanswered

Hide Table Names In Power BI Connector

(0) Share

Report

Posted on by IFEJohn

When I connect to Dataverse from Power BI, using a limited security role, the user still sees all of the table names in the Environment. However, when the user tries to select the table and see the data, there is a permission error. In my case, the table names are sensitive and something I prefer to hide from the user. After exploring all of the permissions for the security role, I did not see any options to hide the table names. Do you know if is possible?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hello, @IFEJohn, If the users have at least Read access to your tables, then you can't hide the tables' names when connecting from the Power BI.

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

Was this reply helpful? Yes No
IFEJohn 54 on at

Like (0)

Report

Thank you @AhmedSalih. To confirm, is it an all or nothing situation? ...or, is it that if we assign read-only access to an individual table then only that table will be be show in Power BI?

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (1)

Report

@IFEJohn, you can create custom security roles and assign read access to specific tables. Depending on your requirements, you can either create a custom security role from scratch or copy an out-of-the0box role and then edit your custom entities permissions:

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other community members find it more.

My Blog: www.powerplatformplace.com

Was this reply helpful? Yes No
IFEJohn 54 on at

Like (0)

Report

Thank you @AhmedSalih. I understand how to create table based access, but I am more interested in understanding if it is possible to limit the user from seeing all of the table names when using the guest credential, even though their custom credential only grants read access to a specific table.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@IFEJohn, so, if your guest have read access to only a specific table, they won't be able to see other tables at all. If I understand your use case clearly, those tables will be used in Power BI. So what don't you create the Power BI Dataset, and rename the tables in it and then share that data set with your guests?

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

IFEJohn 54 on at

Like (0)

Report

When I set the permissions for the tables in Dataverse, even if I specify a single table for read only access, all table name are visible in Power BI for the guest account, though the user cannot access the data from all of the tables.

What do you mean by "create a Power BI data set"? Is this done in Dataverse? From Power BI?

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@IFEJohn, if you are using Power BI desktop, loaded the data from the Dataverse and build your data model. This is a Power BI dataset. Once published to the power Bi service, it will be a dataset object. In the Power BI Desktop, you have the option to rename those tables.

Was this reply helpful? Yes No
IFEJohn 54 on at

Like (0)

Report

Thank you @AhmedSalih. The ultimate goal is to have my customer have access to a sub set of my Dataverse data set so they can visualize in their own Power BI tenant. I do not want them to see any tables or any other Dataverse entities that do not pertain to the sub set of data I define for them. Are you suggesting above that I connect to my Dataverse, use Power Query to create the data set, Publish that, and then share that with my customer?

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (1)

Report

@IFEJohn, I think this is the best route you can take to achieve your requirement.

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

IFEJohn 54 on at

Like (0)

Report

Ok, thanks. So when they go to access the data in Power BI, they select "Power BI Dataset"? If they use the same credential and select "Dataverse", will they see all of the database table names? I have tested, and the account can see all the Dataverse table names, even though I only grant them read only access to one table. Perhaps I have something configured incorrectly.

Was this reply helpful? Yes No