web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / unable to add some tab...
Power Apps
Unanswered

unable to add some tables from Business Central as a virtual table to dataverse

(0) ShareShare
ReportReport
Posted on by 597
(Business Central Virtual Entity v1.0.24179.1 installed)
 
I have been able to add some Business Central tables as a Virtual Table through their API (like Customer as "dyn365bc_customer_v2_0"). 
 
However, when trying to add some other tables by changing their "Visible" toggle to yes in the table "Available Business Central Table", I get the error
 
Invalid type of table key. Only unique identifiers (GUID) are supported
[Microsoft.Dynamics.BCVirtualEntityGeneration.Plugins:Microsoft.Dynamics.BCVirtualEntityGeneration.Plugins.GenerateVirtualEntityPlugin]
[8a72e600-7314-47b9-9057-a751781fa4c5: Microsoft.Dynamics.BCVirtualEntityGeneration.Plugins.GenerateVirtualEntityPlugin: Update of dyn365bc_businesscentralentity]
As a test, I created my own simple API AL Page, as following, but that doesn't solve the error...
page 52102 myapitest
{
    APIGroup = 'myapigroup';
    APIPublisher = 'mypublisher';
    APIVersion = 'beta';
    ApplicationArea = All;
    Caption = 'myapitest';
    DelayedInsert = true;
    EntityName = 'mycustomer';
    EntitySetName = 'mycustomers';
    PageType = API;
    SourceTable = Customer;

    layout
    {
        area(Content)
        {
            repeater(General)
            {
                field(name; Rec.Name)
                {
                    Caption = 'Name';
                }
                field(id; Rec.SystemId)
                {
                    Caption = 'id';
                }
            }
        }
    }
}
 
I have the same question (0)
  • Suggested answer
    KoJaPD Profile Picture
    597 on at
    apparently, adding the following line to the API page solved it:
     
    ODataKeyFields = SystemId;
     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard