Skip to main content

Notifications

Community site session details

Community site session details

Session Id : z8Ny8zHarhuJMkDEmW+chR
Power Apps - Microsoft Dataverse
Suggested answer

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

Like (1) ShareShare
ReportReport
Posted on 26 Mar 2024 10:44:56 by 292 Super User 2025 Season 1

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 

Muzammil_069506_0-1711450442607.png

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:
  • Suggested answer
    Behnam Profile Picture
    2 on 02 Oct 2024 at 14:18:07
    Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation
    You need to add your user to F&O because the ODATA query is sent under your user. 
  • Franzi Profile Picture
    33 on 15 Apr 2024 at 13:59:32
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    Hi, I would expect Microsoft support to help you until it works, isn't it? Unfortunately, I don't want to invest too much time into this. Can you maybe ask your D365-implementation/consultancy partner? BR

  • Muzammil_069506 Profile Picture
    292 Super User 2025 Season 1 on 15 Apr 2024 at 13:18:58
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    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 ?

     

  • Franzi Profile Picture
    33 on 15 Apr 2024 at 13:15:02
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    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

  • Markus12 Profile Picture
    2 on 11 Apr 2024 at 11:08:11
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    Hi Franzi

     

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

  • Franzi Profile Picture
    33 on 27 Mar 2024 at 12:24:21
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    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. 

  • Muzammil_069506 Profile Picture
    292 Super User 2025 Season 1 on 27 Mar 2024 at 10:19:06
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

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

  • Franzi Profile Picture
    33 on 26 Mar 2024 at 11:47:26
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

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

    Franzi_0-1711453632481.png

     

  • Muzammil_069506 Profile Picture
    292 Super User 2025 Season 1 on 26 Mar 2024 at 11:41:52
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    @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 ?

  • Franzi Profile Picture
    33 on 26 Mar 2024 at 11:19:23
    Re: Issues with Virtual Tables for Dataverse in Dynamics 365 Finance and operation

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,771 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard

Featured topics