cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccharker Frequent Visitor
Frequent Visitor

OLE DB or ODBC error unable to connect to remote server

Hi all,

I am hoping someone may be able to explain an error that I am receiving that is a bit strange.  I am using Power BI Desktop to connedt to Project Online.  I am successful in connecting and bringing down data for all tables other than the Project table (which returns an OLE DB or ODBC (Data Source Error), Unable to connect to remote server.

 

I get the preview to load all OK, but when I select to load the details it bombs out.

 

This is bizare as it will load other tables with no issues.

 

Anyone have any ideas?.....This is doing my head in.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: OLE DB or ODBC error unable to connect to remote server

I've sen something similar to this with CRM Online data and in my case it came down to selecting less columns. You might try only importing a single column and see if that works. If it does, perhaps it is an issue with a particular column or the number of columns you are pulling down.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ccharker Frequent Visitor
Frequent Visitor

Re: OLE DB or ODBC error unable to connect to remote server

This is brilliant....fixed my problem.

 

 

thanks

2 REPLIES 2
Super User
Super User

Re: OLE DB or ODBC error unable to connect to remote server

I've sen something similar to this with CRM Online data and in my case it came down to selecting less columns. You might try only importing a single column and see if that works. If it does, perhaps it is an issue with a particular column or the number of columns you are pulling down.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ccharker Frequent Visitor
Frequent Visitor

Re: OLE DB or ODBC error unable to connect to remote server

This is brilliant....fixed my problem.

 

 

thanks