Announcements
Hi Team,
We have a requirement to create canvas app and connect it to the finance and operations which is in other environment to do all the CRUD operations from the powerapps.
For that we are trying to set up a virtual entity concept to build a connection between these two instances.
By following the below provided documents we tried to setup everything, but at the final step when iam trying to get all the "Available Finance and Operation Entities" through the Advanced find, it is throwing an error saying that "An error has occured" in the Dataverse.
1.https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/admin-reference
Error is occuring when iam working on steps 6 & 7 on link-2 "Generate Virtual Entities section".
Any help would be appreciated.
Thanks in advance.
Regarding your error. If you deploy environment using new power platform integration and configure DW application using LCS , things like DW , virtual entities etc are configured for you and you don't have to follow manual steps.
Are you using tier 1 or tier 2 environment?
If you are using virtual entities all your users needs to have license in F&O.
Regarding S2S user, read below snippet from standard documentation - learn.microsoft.com/.../virtual-entities-overview
During the S2S calls, Dataverse provides the identity of the user in Dataverse who is invoking the action. The CDSVirtualEntityAdapterService web API looks up the associated user in finance and operations apps and runs the query in the context of that user. Therefore, the S2S call doesn't have to have explicit access to all the finance and operations entities.
Hi Pavan,
I don't know exactly the border on security where the S2S user comes to play. Not sure if this user can see the list with entities or not. At least, the users should have roles (and licenses) assigned in Dynamics 365 F&O to interact with the data.
Hi Andre,
Thank you for the response.
You mean, the S2S user is only to make the integration between the instances? It means if i want to find the "Available Finance and operations entities" in Dataverse, Is the S2S User is sufficient or do i still need to provide an access to the interactive user who is trying to access the virutal entities from dataverse?
I mean not about the data access,but to setup/getting the list of virutal entities in Dataverse as shown below.
Is there a way that one can access the data from virutal entities with out having access to the data in Finance and operations?
Scenario:
We have some 300 users who are trying to access the data from finance and operations through virutal entities and doing CRUD operations in powerapps.So, do i need to provide access to all these users for Finance and operations instance?
Thanks in advance.
Best Regards,
Hi Pavan,
The S2S application user is used to make the integration between the F&O Virtual entity plugin on Dataverse and F&O. To be able to interact with the data, the user needs to have permissions on data entities.
Hi Andre,
Thanks for the quick response.
Yes, I have assigned the correct role as per the document.
Also the secret is correct too.
FYI,
I added my user to the Finance and operations instance and assigned a "system admin" role, and then it started working, but when i try to access it without my user account(i.e., Interactive user who is trying to make the call from cds) in finance, it is not working.
When iam trying to access data with s2s app user, it is not working.
Any interactive user of Microsoft Power Platform who tries to access finance and operations data through a virtual entity must also exist as a user in finance and operations. Therefore, technically, not all users have to be users in finance and operations. Only those users who access finance and operations data through virtual entities must be users in finance and operations.(Working)
A S2S application user can also be used to call into virtual entities. For this kind of integration, the application user must be set up in System administration > Setup > Configure Azure Active Directory Applications. This allows for applications to integrate with finance and operations using virtual entities.(Not Working).
Do we need to create all the Interactive users in finace and operations to access data/virtual entities from Finance and operations?
Regards,
Hi Pavan,
Can you verify if you have the correct role assigned to the user which is linked to the app registration details on the form Azure Active Directory applications in Dynamics 365 F&O?
For the Virtual entity connection, did you provide the correct value for the AAD Application secret?
André Arnaud de Cal...
293,304
Super User 2025 Season 1
Martin Dráb
232,149
Most Valuable Professional
nmaenpaa
101,156
Moderator