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.
Helper IYes you are right we are connecting through Webservices online without on premises data gateway. We only have Pro license and I guess it's not possible to get premiuim as per the cost. We tried to minimize the coulmns and query steps but still getting this errors.
Could you suggest or by any chance do you know how to connect via API to Business Central? or having Power Apps connected first to Business Central then Power Apps to Power Bi? Thank you.
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.
- CampBI
Hi Anonymous Thank you for this. I don't have background connecting using the API is this needs admin access? Thank you.
Can I use dataverse as database if the API is not set up? Could this help on the refresh real time?
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.
- CampBI
Thank you. Upon analyzing API is best option but we do not have a developer to put up an API from Business Central to Power bi. Do you have recommendations?
Hello CampBI,
If you don’t have a developer, no worries. You can still connect Power BI to Business Central without creating your own API. Power BI already has a built-in Business Central connector that works through the API automatically.
Just open Power BI Desktop → go to Get Data → Online Services → Dynamics 365 Business Central, and sign in with your Business Central account. After that, you can pick your environment and tables to load the data.
please go through with the below document and screenshot hope it may resolve your Issue:
https://learn.microsoft.com/en-us/dynamics365/business-central/admin-powerbi-setup
https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-use-financials-data-source-powerbi?tabs=existing
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Support Team.- CampBI
Thank you forv the reply. Currently this is how we connect by native connector which results to timed-out loading error. So I have to find a solution for it.