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