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
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