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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
uvil
Helper I
Helper 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!:
The Definitive Guide to Power Query (M)

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.