Forum Discussion

V3GAS's avatar
V3GAS
Icon for Helper I rankHelper I
9 years ago
Solved

"OLE DB or ODBC error: [DataSource.NotFound]" when loading table

Using Power BI Desktop to connect to a Project Server 2013 database using the OData Feed option, I am able to: Connect to the database Select a table from the database See a preview of the data i...
  • V3GAS's avatar
    V3GAS
    9 years ago

    Good News...

     

    I was able to connect using the OData Feed to our on-premises Project Server 2013 and apply the table in question to the report. I found that it was corrupt data in the table. 

     

    I slowly and methodically vetted the columns in the table by removing/replacing them and trying to apply to the report. As a matter of fact, it was a series of columns that was causing the issue. By keeping them out of the query, I am now able to utilize the data in the report.

     

    Thanks.

keinshah's avatar
keinshah
Icon for Helper I rankHelper I
2 years ago

I face a similar problem. 

 

DataSource.NotFound: Dynamics365BusinessCentral: Request failed (404): The remote server returned an error: (404) Not Found. (The Sales Header does not exist. Identification fields and values: Document Type='Order',No.='STNLSO001653' CorrelationId: 9102fe11-c4ec-44df-8064-95097bd438f8.)
Details:
DataSourceKind=Dynamics365BusinessCentral
DataSourcePath=Dynamics365BusinessCentral
Url=https://api.businesscentral.dynamics.com/v2.0/PRODUCTION/OData/Sales_Order_Line?company=SMART

 

Any idea how to solve it?