Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
waldemar100

Unable to refresh Power BI dataset, getting data from Business central

Submitted by on ‎05-02-2022 05:33 PM

Since saturday 30-May-2020, a power Bi dataset retrieving data from business central, stopped being able to refresh.

Processing error: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

This dataset was working fine for months.  In Power Bi, there is a link to sumethign that suggests the same error that I am getting but in data flows. And it says it will be fixed at the end of june?

 

 

waldemar100_0-1651537928211.png

 

Status: Delivered

The status on the support page is applied to Power BI Dataflows, not datasets.

 

In this issue, if the Business Central represents Dynamics Business Central that you have connected to, there is a similar issue which had been submited previously(ICM: 290761727😞

If user is loading a lot of data to their report. That causes Business Central to be slow providing the data, Power BI to be slow processing the data, and in the end timeouts to occur in the communication between the two. To solve this issue, we recommend the user tries to optimize their queries to

1) reduce the amount of data loaded by the reports and

2) reduce the number of calls sent to Business Central

 

Here are a few suggestions to achieve this:

1) Filter data in Power Query Editor before publishing this report to Power BI Service

2) Use the Expand feature in Power BI. using this feature, they can get the Dimensions for some record directly into the record itself in Power BI (notice: this depends on which API page or web service they are using). This saves a lot of calls to Business Central. 

3) Try to use API pages instead of Web Services. API pages are more performant and are more optimized for bulk data operations, whereas Web Services are sometimes slower and less optimized. Also, API pages often contain references to the related records, which means they can use the Expand feature as per the point above

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎05-03-2022 06:10 PM
Status changed to: Delivered

The status on the support page is applied to Power BI Dataflows, not datasets.

 

In this issue, if the Business Central represents Dynamics Business Central that you have connected to, there is a similar issue which had been submited previously(ICM: 290761727😞

If user is loading a lot of data to their report. That causes Business Central to be slow providing the data, Power BI to be slow processing the data, and in the end timeouts to occur in the communication between the two. To solve this issue, we recommend the user tries to optimize their queries to

1) reduce the amount of data loaded by the reports and

2) reduce the number of calls sent to Business Central

 

Here are a few suggestions to achieve this:

1) Filter data in Power Query Editor before publishing this report to Power BI Service

2) Use the Expand feature in Power BI. using this feature, they can get the Dimensions for some record directly into the record itself in Power BI (notice: this depends on which API page or web service they are using). This saves a lot of calls to Business Central. 

3) Try to use API pages instead of Web Services. API pages are more performant and are more optimized for bulk data operations, whereas Web Services are sometimes slower and less optimized. Also, API pages often contain references to the related records, which means they can use the Expand feature as per the point above

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses