Using Power BI Desktop to connect to a Project Server 2013 database using the OData Feed option, I am able to:Connect to the databaseSelect a table from the databaseSee a preview of the data in the tableQuery the table and see all data When I try to load/apply the table into the report, I receive the following error:To get the above table query, I have set the OData Feed permission to use Windows authentication. Does this have anything to do with the permissions? When trying to use the Organizational Account option, I get another error:

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.

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

Forum Discussion

Related content

Microsoft Load

Cannot Load Model

"Found illegal OLE automation date" but date field is OK in Power BI and behaves as expected?

Load Date

Getting Error Cannot load model