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

OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

Using PBI desktop connecting to a cloud-based source using an ODBC connection.

 

Has been working fine until one of the views I'm refreshing has started returning the above error message.

 

I need a definitive "translation"of the error message.

 

I think it is an issue with the data, and need to be able to locate which data as well.

 

Suggestions?

7 REPLIES 7
Highlighted
Solution Sage
Solution Sage

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

Hi @rodjarman

 

This is probably coming from calculated columns or relationship can you go to Options > Data loading > And disable the one that detect new relations and the one that import relations from other sources ? 

Then try again

 

- Quentin

Highlighted
Frequent Visitor

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

Thanks Quentin.

 

I've isolated the view into a separate desktop file. There are no relationships and no calculated columns.

 

Turned off the options you suggested. Attempted import. Still get the same error message. Smiley Frustrated

 

Highlighted
Solution Sage
Solution Sage

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

@rodjarman

 

So even when you try to import the view in a new PBI file it display this error ? 

 

Can you post a sample of your data so that I have an idea ? (If it's sensitive you can make them anonymous or not post it as you want)

 

 

- Quentin

Highlighted
Frequent Visitor

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

So even when you try to import the view in a new PBI file it display this error ? 

 > Yes that's correct.

 

Can you post a sample of your data so that I have an idea ? (If it's sensitive you can make them anonymous or not post it as you want)

> Is it practical ... as there is 102 columns.

 

That's why I was more after a translation of the error code. 

Highlighted
Solution Sage
Solution Sage

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

@rodjarman

 

Ok, it's going to be complicated for you to post the data here.

 

Can you copy or screenshot the full error message ? Because it's looks like the title of your topic has been cut or something (not sure)

 

- Quentin

Highlighted
Helper III
Helper III

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

Did you find any additional information on this error message?  I started getting the same one with my report.  I have not changed anything to the Power BI file, but I am now unable to refresh it...

Highlighted
Anonymous
Not applicable

Re: OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..

I am facing with the same issue! my query has arround 200.000 rows. anyone solved this issue? tks

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.