Forum Discussion
Dataflows being inconsistent (Business Central data)
Are you connecting with OData or ODBC? if odbc, have you installed the appropiate driver? if you have, it looks like the source is not leting you in to read data. To proceed, ask a IT or DB admin to help you read data from the machine you are running the Power Bi Desktop. It could be that they are preventing connectiongs or requests/queries and that's why it changes messages each time it refreshes (one time it fails with table 1, then with table 3, other day with table 5)
I hope that make sense
Hi ibarrau,
Thank you for the reply. The weird thing is that the error occurs in different tables in the dataflow each time. These tables will work with the next refresh and then a error occurs in another table if i check the refresh log (so the problem does not seem to be in the tables themselves). Also what stands out to me is that the issues started on the same date at both the companies.
Maybe the issues are caused on the Business Central side, so i might have to post this on a forum there aswel.
As of for now i am very clueless of what it might be. If i may ask, do you have dataflows running on business central or are they connected to another source?
Yes it's weird, but start with the debug to make sure it's not the code. This can be timeouts or issues at data sources. When a datasource can't reply in specific time it can be cancelling the request and it changes which table is failing depending on the reponse time. When code is ok, then sources can be the next step. The sources processing time or timeouts for connections/commands.
I hope that make sense
Hi Ibarrau,
I have tried copying the queries into Power BI desktop. When loading i now get the following error message:
OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..I have been looking around but cant really find anything on how to fix this in our use case. Do you maybe have any clue as to how we can fix this?
Are you connecting with OData or ODBC? if odbc, have you installed the appropiate driver? if you have, it looks like the source is not leting you in to read data. To proceed, ask a IT or DB admin to help you read data from the machine you are running the Power Bi Desktop. It could be that they are preventing connectiongs or requests/queries and that's why it changes messages each time it refreshes (one time it fails with table 1, then with table 3, other day with table 5)
I hope that make sense