Forum Discussion
Helper IBusiness 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.
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.,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.
Hi CampBI,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.Hi CampBI,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.
CampBIHi Again, I would like to know how this API set up to Power Bi? For our existing report