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 mak...
Need Help
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

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

        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.