Business Central data source error - An existing connection was forcibly closed by the remote host.

Hi CampBI,

Since you are using Business Central Online with Pro license, the 2-hour refresh limit in Power BI is expected. To go beyond that, Premium is needed, but I understand it may not be possible right now.

Instead of Web Services, you can try using Business Central APIs they’re lighter and may reduce timeout issues.
You can connect in Power BI using the API link like this "https://api.businesscentral.dynamics.com/v2.0/{tenant_id}/{environment}/api/v2.0/".

Just use Web or OData connector and sign in with your Business Central account. And about PowerApps yes, you can pull data from Business Central to Power Apps, then connect Power BI to that data (like from Excel or SharePoint). But please check licensing once for Power Apps.

I suggest trying the API method first, as it’s simpler and works well in many cases.

Best Regards,

Harshitha.

Hi CampBI,
Yes, to connect using the API, you might need some help from your admin mainly to get the tenant ID, environment name, and to confirm API access is allowed in Business Central. Once that’s done, you can connect from Power BI.
Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/

coming to dataverse  yes, if your data comes into Power Apps, you can use Dataverse as a middle layer. Power BI can connect to Dataverse using DirectQuery, which helps in near real-time updates. But setup might be a bit complex and may need proper licensing.
go through with the below document hope it may resolve your Issue:
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/use-powerbi-dataverse

Hope this helps if you have any queries we are  happy to assist you further.
Best regards,
Harshitha.