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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi V3GAS,

From your description, you are connecting to on-premises Project Server rather than Project Online from Power BI Desktop, right? If that is the case, I haven’t found any official articles or blogs stating that how to connect to on-premises Project Server and what authentication method in Power BI Desktop.

Could you please configure basic authentication type in Project Server and use basic authentication in Power BI Desktop? I also find an idea about adding add-on for on-premises Project Server, if you still get errors when exploring Project Server data in Power BI Desktop, please vote that idea.

However, if you connect to Project Online from Power BI Desktop, please follow the instructions in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-project-online-connect-to-data/ .

Thanks,
Lydia Zhang