Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Business Central Virtual Table: Can't create Table

Posted on by 115

Hello,

I'm trying to set up Business Central Virtual Table for Microsoft Dataverse. For this I used the setup wizard in Business Central. After setup, I also find the appropriate record in the msdyn_businesscentralvirtualentity dataverse table and can see all available tables/APIs in the mserp_businesscentralentity table. However, I cannot activate them.

When I check Visible on a record and try to save the record, I get this error: 0x80048d0b.

Can anyone tell me what this error means. Or even how to fix it.

Thank you and best regards
Nico

Technical specifications
Business Central 21.0 (Platform 21.0.46384.48092 + Application 21.0.46256.46853)
Dataverse: Sandbox in Europe

  • Verified answer
    GER_Nico Profile Picture
    GER_Nico 115 on at
    RE: Business Central Virtual Table: Can't create Table

    I solved the problem. It was a language conflict.

    The documentation says that you should activate the virtual tables directly in Dataverse. However, if you include the table in a model-driven app and try it there, you will get a more detailed error report. And it says "The language code 1033 is not a valid language for this organization". Language code 1033 is English, but my PP environment has German as the default language. In order to fix the problem, English must be activated as an additional language in the PP environment.

    In a nutshell: In order to be able to use the D365 app "Business Central Virtual Table" the language English must be active in the PP environment. Whether as the primary or as an additional language.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Business Central Virtual Table: Can't create Table

    Please raise a support ticket to Microsoft.

    Thanks.

  • GER_Nico Profile Picture
    GER_Nico 115 on at
    RE: Business Central Virtual Table: Can't create Table

    Unfortunately that didn't help.

    The error occurs even when trying to connect a clean new BC environment to a clean new PP environment.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Business Central Virtual Table: Can't create Table

    Hi,

    Please visit the below link to get more insight.

    learn.microsoft.com/.../cannot-set-dataverse-virtual-table-visibility

    Thanks.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans