Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Virtual table on sql view error on single report

(2) ShareShare
ReportReport
Posted on by 6
Hello,
I've made a virtual table based on SQL View.
 
When I open the virtual entity on Dynamics, all record are visualized correctly.
But when I try to open single record by clicking on my /All record/ view of my virtual table, I've this error.
APIM request was not successful : StatusCode : BadRequest, Reason : The specified item 'db4383b4-0684-4c49-9475-384dcae98f0c' is not found.
 
Somebody have an idea to resolve this problem?
 
Thanks in advance
  • DM-28111358-0 Profile Picture
    DM-28111358-0 4 on at
    Virtual table on sql view error on single report
    I'm having this same problem right now.

    About your suggest to use a primary key, it is imposible to use at level of SQL Sever views. Actually I'm using a number value to use as a primary key from view source. But in the case of Gianluca, he is using GUID and he is getting the same problem.

    I don know if configuring a GUID instead a number key is the solution.
  • DM-28111358-0 Profile Picture
    DM-28111358-0 4 on at
    Virtual table on sql view error on single report
    I'm having this same problem right now. If you have any updates on the problem, I would appreciate your comments.
     
    In my case, I'm using a view from source with a number primare key.
  • Virtual table on sql view error on single report
    I'm having the same issue.
    Were you able to get around it?
    I can't find any solutions anywhere.
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Virtual table on sql view error on single report
    Hi Partner,
    Maybe you can refer to the following link, check that the GUID field is marked as Primary Key:
    Also, you can refer to following links to check all possible reasons:

    I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
    Regards,
    Leah
     
     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans