Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

(1) Share

Report

Posted on by Muzammil_069506

292 Moderator

I am currently working on setting up virtual entities in Dynamics 365 and have encountered some issues. I followed the setup instructions as per the guide on the Microsoft Learn website, but after enabling virtual entities, not all entities are being reflected as expected.

when i go and see in advance find available finance and operation entities

it gives me error i just want the entities finance and operation entities to be used in dataverse enviornmnet

i have followed these steps Configure Dataverse virtual entities - Finance & Operations | Dynamics 365 | Microsoft Learn

but when im enabling the virtual entities Enable Microsoft Dataverse virtual entities - Finance & Operations | Dynamics 365 | Microsoft Learn

i cant find in advance

error 2024-03-26 134153.png

Categories:

Microsoft Dataverse with Power Apps

error 2024-03-26 ...

I have the same question (0)

All responses (12)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@Muzammil_069506

Are you getting this error when you just open advanced find or when your run a query against available entities for finance and operations?

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

@Mira_Ghaly when i just open advance find and thein the lookup enter available finance and operation entities and hit on result it throws this error , i just want to know if my initial configuration was right so that i can use those virtual entities

Was this reply helpful? Yes No
Franzi 33 on at

Like (2)

Report

I know this error. In my cases there was usually something wrong with the app registration resp. the associated Entra User - User rights in FO. And your personal user needs at least a Sys-Admin in FO and the "Finance and Operations Integration User" on the power platform side.

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

@Franzi thanks for reply personal user as in ?ca you explain on that please and wht if the user has system admin role that doesnt have affect ?

Was this reply helpful? Yes No
Franzi 33 on at

Like (1)

Report

The user that you are signed in to the power platform with.

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

Though I have given role it doesn't seem to be work do i need to take care of anything else. @Franzi

Was this reply helpful? Yes No
Franzi 33 on at

Like (1)

Report

What's the role of your personal user in F&O? Do you have the system administrator? You have set up a Microsoft Entra ID application inside of F&O, right? This will be assigned to a service user and the service user in F&O should probably have the role "Dataverse Virtual entity integration app" formerly known as "CDS Virtual Entity Application". I've mainly used the following blogpost for it: Setting up Virtual Entities for Microsoft Dynamics 365 Finance and Operations in the Common Data Service – Dyanamics Post (dynamicspost.com). But it's from 2020 and Microsoft just loves to rename things...If this doesn't help, you can still open a support ticket, I guess.

Was this reply helpful? Yes No
Markus12 2 on at

Like (1)

Report

Hi Franzi

I have the same issue. Did you had some progress or got a solution?

Was this reply helpful? Yes No
Franzi 33 on at

Like (1)

Report

Hi Markus12,
my problems are solved for long now.
I can just give you the hint to make sure, that the app registration user and your own user have the right permissions in FO and in the power platform.
Recently I mostly work on Sandboxes using the Power Platform Integration (LCS).
BR

Was this reply helpful? Yes No
Muzammil_069506 292 Moderator on at

Like (1)

Report

Hi Franzi by any chance i had raised a ticket with microsoft as well they said to generate new client id and secret but doesnt seems to work ,by any chance if we can connect ?

Was this reply helpful? Yes No