Re: OLE DB or ODBC error: [DataSource.Error] Micro...

huguest · ‎10-22-2018

Hello,

My report will no longer refresh and is returning this error:

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

I did not make any changes to the report, and it was refreshing without any issue before (i.e. last week).

Any help would be appreciated.

randymarchena · ‎08-13-2019

and did you solved this error? how?

I have the same error message

PattemManohar · ‎10-22-2018

@huguest Are you able to connect to the same database through SSMS (SQL Server Management Studio).

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

Proud to be a PBI Community Champion

huguest · ‎10-22-2018

I am not an IT person, so I am not able to answer that question. I was able to preview the query in the Quety Editor, and refresh the preview, without any problem though.

v-piga-msft · ‎10-31-2018

Hi @huguest,

Do you have this error message when you click Refresh Button in Power BI Desktop?

Is your data source Sql Server Database?

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

huguest · ‎11-01-2018

Yes, I do have the error when I click on Refresh (not immediately, only after a while). I have several data sources but one of them is a sql database.