Unanswered

Virtual Table permissions for Model App Use

(0) Share

Report

Posted on by AWM

Hello,

I have a Virtual connector table setup in an environment and I cannot work out how to give users access to the data in this table. I have created a Model Driven app which has a view from the virtual table. Users can access the app page but the view says there is no data. When I view the app I see the data OK.

I have confirmed the following in trying to work out the issue:

The Connection (to on premise SQL) used by the virtual table is shared to the org
The user is assigned to a security group which has access to read, write etc to the table
I have checked a number of other security group settings and all are selected that I believe are needed.

Any suggestions to what may be preventing the users access to the data?

Thanks

Andrew

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @AWM ,

Looks like you have done the correct steps here, You are utilizing an enterprise data gateway vs. a personal data gateway right? https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/gateway-reference#types-of-gateways

Wondering if this might be the issue with the access to the data. If you setup using a personal gateway other users would not have access.

Was this reply helpful? Yes No
AWM 13 on at

Like (0)

Report

Hi,

Thanks for the reply, yes the gateway is an enterprise gateway and the users can access data through it for other tables. It is strange as I have not seen this issue before.

Thanks
Andrew

Was this reply helpful? Yes No
jessefrase 2 on at

Like (0)

Report

Andrew,
Did you ever solve this issue? I am seeing the same behavior with a Canvas App connecting to a virtual table, data from an on premises SQL server.

Thanks,
Jesse

Was this reply helpful? Yes No
AWM 13 on at

Like (1)

Report

Hi Jesse,

I did, although I only have rough notes on how we solved it. I believe the issue was caused by the users not having access to the Connection Reference Entity. Once we gave the security group the users were in READ access to the Connection Reference Entity I believe it then worked. Please note that this was for a Model Driven app, it may not apply to Canvas apps as the security I believe is different. Prior to creating a Model Driven app, the table was being accessed OK in Power Portals without these above permissions applied.

Hope this helps.

Thanks
Andrew

Was this reply helpful? Yes No
AlexinEdmonton 43 on at

Like (1)

Report

I had this issue with a virtual table to SharePoint List. I added read access at organization level to the Connection Reference entity, as AWM suggested, and was then able to see records in my model-driven app.

Was this reply helpful? Yes No