Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Unanswered

Business Central

(0) ShareShare
ReportReport
Posted on by 150

Hi All,

What's the best way to connect Business Central to Power Pages? I've tried virtual tables so far, however, I am not able to see the data when I create a list view or a form in Power pages. It is returning the following error 'We're sorry, but something went wrong. Please try again, and if this persists, contact the website administrator.'. 

 

Does anyone know how to solve this issue?
Should I keep using virtual tables or is there a better way?

 

Thanks in advance.

Categories:
  • enes Profile Picture
    150 on at
    Re: Business Central

    Thanks for your reply again. Do you know exactly what makes using Integration Tables more stable? 

  • Samantha73 Profile Picture
    4 on at
    Re: Business Central

    options

    You have to create a Dataverse table and then trigger a power Automate function that does the call.

    Or working with the sync with Business Central. I think that is a more stable solution (Customizing an Integration with Microsoft Dataverse - Business Central | Microsoft Learn).

  • enes Profile Picture
    150 on at
    Re: Business Central

    @Samantha73 Thanks for your reply.

    >"You can sync data to a dataverse table using Odata API or use power pages Web API."

     

    Does this work both ways? If I insert a row in a Dataverse table through Power Pages, would it reflect in Business Central immediately? Is it possible for the Dataverse and Business Central tables to go out of synch?

  • Samantha73 Profile Picture
    4 on at
    Re: Business Central

    Power pages cannot connect to Business Central via virtual tables. You can sync data to a dataverse table using Odata API or use power pages Web API. For reporting embed Power BI 

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >