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

[huguest]

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]

and did you solved this error? how?

I have the same error message

[PattemManohar]

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

[huguest]

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]

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

[huguest]

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.