Forum Discussion

huguest's avatar
huguest
Icon for Advocate II rankAdvocate II
7 years ago

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

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.

Need Help

5 Replies

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

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

    • huguest's avatar
      huguest
      Icon for Advocate II rankAdvocate II
      7 years ago

      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's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        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

  • randymarchena's avatar
    randymarchena
    Frequent Visitor
    7 years ago

    and did you solved this error? how?

    I have the same error message