Forum Discussion
PowerBI error OLE DB or ODBC error: [DataSource.Error] with new Dynamics Business Central Datasource
Microsoft converted our Dynamics Financials and Ops, Business Tenant on Friday. Now our PowerBI visuals from the old Finance and Operations, Business data is not working in their new Dynamcis Business Central.
On LOAD of Datasource"Bank_Account_Ledger_Entries" (and a few others) from our new Dynamics Business Central Tenant it fails to load and throughs error:
Bank_Account_Ledger_Entries
OLE DB or ODBC error: [DataSource.Error)
Dynamics3658usinessCentral: Request failed: The remote server
returned an error. (500) Internal Server Error. (An error has occurred.).
Any thoughts.
Hi mikekurm,
Based on your description, the error occurs because the Dynamcis Business Central has been changed. Please check if there's something wrong in new tenant or there's some configuration in need in the new tenant.
In addtion, it seems like your issue is more related to dynamic365. I recommend you to post the issue in dynamic365 forumn for further support.
Regards,
Jimmy Tao
1 Reply
Hi mikekurm,
Based on your description, the error occurs because the Dynamcis Business Central has been changed. Please check if there's something wrong in new tenant or there's some configuration in need in the new tenant.
In addtion, it seems like your issue is more related to dynamic365. I recommend you to post the issue in dynamic365 forumn for further support.
Regards,
Jimmy Tao