Hi,
We are a small company, we do not have datalakes or data warehousing capabilities but want to utilise the data within our cloud BC to build Power BI reports within the PBI environment.
I have set-up multiple Power BI dataflows to extract data from Business Central and all dataflows work well apart from the General ledger (Page 20 General Ledger Entries) which keeps on falling over, not all the time but enough to annoy me. The error i get is:
"Error: DataSource.Error: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."
Our small IT team don't know if this is a Power BI dataflow or Business Central issue forcing the connection to close, does anybody know how to fix this issue?
The dataflow is pulling 3 companies General Ledger Entry data about 70k rows in total across the 3 companies.
I have tried splitting the connection out based on the posting date where i updated the Odata connection string to filter greater than 1st Jan 2021 so 6 months data but it still falls over all the time.
I have tried using a Web Api / Json format connection which worked extremely fast in comparison to the Odata connection but for some reason the connection did not extract all the data. On a small sample comparison i looked at with no date filters applied to the connection the Web Api Json connection only started from GL entry number record 320 so literally missing the first 319 records which i have no idea why as i did not customise the connection it was a standard Web Api connection.
Any help would be appreciated.
