Business Central

(0) Share

Report

Posted on by enes

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:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Samantha73 4 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
enes 150 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Samantha73 4 on at

Like (0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
enes 150 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No