Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
uvil
Resolver I
Resolver I

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, 

errorcode.png

Hope this message helps, 

 
1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

Angelvelz90p@gmail.com

chiragshah
New Member

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

Greg_Deckler
Super User
Super User

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

 

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:
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".


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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

amitchandak
Super User
Super User

@uvil , Some issue with Connecting with the source. check VPN of Ip whitelisting .

refer

https://support.microsoft.com/en-in/help/966146/run-time-error-2147217900-80040e14

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.