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 hap...
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

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