Colleague cannot see the data in my app that was created with Dataverse tables.

(0) Share

Report

Posted on by Baltner

149

Greetings:

Because the app I'm developing uses several many-to-many relationships among the data tables I decided to use Dataverse for a new app instead of my usual reliance on SharePoint lists. It worked out beautifully until today when I tried to share the app with a colleague and found out that he cannot view the data (gets a network error alert). I tried sharing the tables in several ways, including assigning different security roles in the "Sharing" panel, but so far no good. This is my first attempt to use Dataverse. Can you explicitly share Dataverse tables? I haven't found a way.

The app mentioned above was developed at make.powerapps.com because I felt that developing it in Teams was too limiting. I can add it to Teams and see all the data just fine, but my colleague can't see the data that way either. So I tried a simple experiment and created a single-table app in PowerApps for Teams and published to a channel that he does have access to. He can see these data but not in the full app developed outside of Teams.

In case this is a licensing issue and not a technical one, I did a lot of reading about what kinds of licenses ...which, quite honestly, I find very confusing. But if it is a licensing issue, what is the right license type to allow sharing of Dataverse tables outside of Teams?

Thanks, in advance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Fubar 8,375 Super User 2025 Season 2 on at

Like (0)

Report

Have you configured a Dataverse Security Role for your users and assigned it the users (or a Dataverse Team the users belong to) - this is how you give access to the dataverse tables and data.
https://learn.microsoft.com/en-us/power-platform/admin/database-security#create-or-configure-a-custom-security-role
(note: If you are only using existing out to the box tables you may find an existing out of the box security role that you can use rather than create your own.)

Was this reply helpful? Yes No
Baltner 149 on at

Like (0)

Report

@Fubar Thanks for this great insight into how to share these tables. I spent most of today trying to figure this out, including searches in Google, Bing, and chatGPT, but it wasn't until I posted my question here that I got the right answer. This solution worked beautifully.

Follow-up question: where the heck did all of the other "custom" security roles come from in my environment? There are dozens of them and, as far as I can tell, I'm the only one working on Power Platform solutions in my company's default environment. I don't know what they are for, who made them, and which tables they apply to. Some governance in this area would be very helpful. Maybe the same reference you pointed me to will answer that question as well. It requires further study but for now I've met the main objective thanks to your advice.

Was this reply helpful? Yes No
Fubar 8,375 Super User 2025 Season 2 on at

Like (0)

Report

There a number of out of the box Security Roles that are installed when your Dataverse instance is created, similarly if other Solutions have been imported they may also include there own Security Roles. Generally you leave them alone, or copy one and make your changes to the copy, and give your one a name that makes it easily identifiable as yours.

Was this reply helpful? Yes No