Forum Discussion

uvil's avatar
uvil
Resolver I
6 years ago
Solved

Error Code -2147217900..

Hi, 

 

Since yesterday I have this message error when I refresh the report in Power BI Desktop, it never happened to me, and I'm not able to find any information of this error in the web

 

It happened instantly, and also I'm able to do query's in SSMS, basically doing the query in SQL I got returned the whole table without any problem, so basically now I don't have any clue about where this issue is coming from, 

 

So I guess that this error comes from Power BI but I can't find solutions anywhere, 

Hope this message helps, 

 
Need Help
  • uvil's avatar
    uvil
    6 years ago

    Hey Guys, 

     

    I resolved the problem reseting all the data source connections and cleaning the cache of the report, 

     

    Hope this helps to you in the future, 


    Regards to all

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Wild, according to this:https://stackoverflow.com/questions/50694925/how-to-solve-the-system-error-h80040e14-2147217900-in-excel-adob-connection

     

    The error itself - according to Microsoft - means: The query uses non-ANSI outer join operators ("=" or "=") - though we can see that there are no joins in the query you're sending. Microsoft state that the fix is to either stop using non-ANSI joins, or to wind back the version number of the database to 80 or before. – CLR Jun 5 '18 at 9:27
     
    If you're getting the error without running the SQL command, then it would suggest there is a problem with the connection string DB_CONNECT_STRING - perhaps the database is no longer compatible with it. – CLR Jun 5 '18 at 9:28
     
    Wild, not sure I believe any of that. There is also this:
    https://support.microsoft.com/en-us/help/966146/run-time-error-2147217900-80040e14
    But that's 2018
     
    You could check the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
    • uvil's avatar
      uvil
      Resolver I
      6 years ago

      Hey Guys, 

       

      I resolved the problem reseting all the data source connections and cleaning the cache of the report, 

       

      Hope this helps to you in the future, 


      Regards to all

  • chiragshah's avatar
    chiragshah
    New Member
    3 years ago

    Has anyone solved this for Power BI Online?  Our Desktop version refreshes fine but when we try to refresh online with on-prem gateway for multiple EXCEL file source, we are getting following error:

     

    • Underlying error code-2147467259
    • Underlying error messageAccess to the path '\\ivtapjdeint02\JDE_IE\PM Dashboard\SpecialtyLeasingABR.xlsx' is denied.
    • DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
    • Microsoft.Data.Mashup.ValueError.Detail\\ivtapjdeint02\JDE_IE\PM Dashboard\SpecialtyLeasingABR.xlsx
    • Microsoft.Data.Mashup.ValueError.ReasonDataSource.Error
    • Cluster URIWABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
    • Activity IDcac77607-ea26-438c-8802-68a92b5f43ec
    • Request IDafc484ed-04ff-9842-8ea0-195d5833e90f
    • Time2022-11-30 16:11:45Z

    The file that fails is different every time so I feel it is a timing issue where more than one file is trying to refresh data at once and EXCEL locks up.

     

    Thank You,

    Chirag Shah