Ole db or odbc error exception from hresult 0x80040e4e an unexpected exception occurred

30 REPLIES 30

Ole db or odbc error exception from hresult 0x80040e4e

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I have set up my power bi to work from an excel spreadsheet when I try to refresh I get this error.

OLE DB or ODBC error : exception from HRESULT: 0x80040E4E

It use to refresh no problem but since I have upgraded power bi desktop it seems not to work at all.

Answers

I am not able to reproduce your scenario. Would you mind sharing me your excel file and PBIX file for test?

Please check that if the connection string is changed in Advanced Editor of Query Editor after refreshing data. Change excel file path, re-add the connection string in Advanced Editor and refresh data and check if the error goes away. Here is similar error message for reference.

Источник

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E #797

Getting the above error when connecting my org URL with power BI desktop



Error.txt
Error-Session Diag.txt

Link for reference: COE Starter Kit on Github — powerapps-tools/Administration/CoEStarterKit at master · microsoft/powerapps-tools · GitHub

The text was updated successfully, but these errors were encountered:

can you confirm you only have one row in your CoE Settings table? It sounds like the issue is based on that, as the relationship in Power BI expects that table to only have one row.

Thank you
Manuela

Cc: Rakesh Rout ; Author Subject: [External]Re: [microsoft/powerapps-tools] OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E (#797) Hello, can you confirm you only have one row in your CoE Settings table? It sounds like the issue is based on that, as the relationship in Power BI expects that table to only have one row. Thank you Manuela — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or unsubscribe .

Would you be able to please try something following the steps below?

1. Select Cancel on the load and the Power BI should open (without values)
2. Under Modeling select Manage Relationships
   
3. Look for the Environments — CoE Settings relationship and delete that one
   
4. Once you Save and Close that dialog, the re-load should start and work fine now.

It looks like Power BI auto-detected an unnecessary relationship between CoE Settings and Environment (this is not required) which could be causing this issue. I verified in my tenant that the dashboard still worked after removing the relationship, but if you could try and see if that also removes your error that would be great — and then we can include this change the next time we ship the dashboard.

Cc: Rakesh Rout ; Author Subject: [External]Re: [microsoft/powerapps-tools] OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E (#797) Would you be able to please try something following the steps below? 1. Select Cancel on the load and the Power BI should open (without values) 2. Under Modeling select Manage Relationships [image] 3. Look for the Environments — CoE Settings relationship and delete that one [image] 4. Once you Save and Close that dialog, the re-load should start and work fine now. It looks like Power BI auto-detected an unnecessary relationship between CoE Settings and Environment (this is not required) which could be causing this issue. I verified in my tenant that the dashboard still worked after removing the relationship, but if you could try and see if that also removes your error that would be great — and then we can include this change the next time we ship the dashboard. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or unsubscribe .

sorry the images don’t come through if you reply to the GitHub issue via email — could you go directly to GitHub and paste the images in again?

Thank you
Manuela

Apologies for the delayed response
Attached are the new set of errors.

Cc: Rakesh Rout ; Author Subject: [External]Re: [microsoft/powerapps-tools] OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E (#797) Hello, sorry the images don’t come through if you reply to the GitHub issue via email — could you go directly to GitHub and paste the images in again? Thank you Manuela — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub , or unsubscribe .

Can you please share a screenshot (you will have to paste from within GitHub) of your CoE Settings data?

In your CoE environment > Data >Tables > All > Search for Settings > Select the CoE Settings to open it in edit

Select Data > Change the View to All Columns

And then share this view

and could you do the same for the Environment and Apps table which seem to be blocking the Power BI too.

above image is for query as below

In your CoE environment > Data >Tables > All > Search for Settings > Select the CoE Settings to open it in edit

Select Data > Change the View to All Columns

And then share this view

Thank you for providing this!

1. In your CoE Settings table you have two rows — can you delete both of those rows and add just one new one?
2. It looks like you don’t have data in your tables yet — can you confirm you have turned on the Admin | Sync Flow v3 and that is running successfully? This is populating the App, Environment and Flow tables the Power BI is based on.

Thank you
Manuela

there were two instances here.
With the help of Valentina was able to remove the error , hit refresh now i have only blank table with no data in them

now I see data populating

You’re on a drillthrough screen that only shows data when something is selected from a previous screen. Are all of your pages empty? Can you perhaps go to the Overview — Power Apps page in the dashboard and see if that is empty as well?

The Cloud Flow Details page will be empty unless a cloud flow is selected — on some of the overview and inventory pages you can right click in the table and select Drillthrough > Cloud Flow Detail

Thanks .. i see information in the overview page.. will check on the drill down and update back

Great thank you for confirming!

One way of getting to that page is going to the Cloud Flow Archive page and selecting a flow, right clicking on it and selecting Drillthrough > Cloud flow detail and that should then show you details about an individual flow.

Closing out issues with no further action.

© 2023 GitHub, Inc.

You can’t perform that action at this time.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.

Источник

OLE DB or ODBC error by getting data #41

We’re trying to run the CCO Report.
Every time we run the data collection, it ends in the following error:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

We tried all the issue fixes and went to all fixed in the Troubleshooting Guide but nothing helped.

The text was updated successfully, but these errors were encountered:

Only one error is expected on the first run if all the configuration is properly set because Power BI is not asking for the graph API authentication and is simply fixed by refreshing the dashboard after the first run…

I tried to refresh, same issue, ODBC error. After I did a cleanup in the Datasource Credentials before I refresh, the following «error» shows up every time

and the PowerBI crashes.

Can you check the privacy level?

Can you check the URL? just to see which resource provider fails

I didn’t change the settings here. I only add my credentials.

Are you using an outlook or a hotmail account? because graph API doesn’t work with this type of accounts

I’m using my Azure AD account. We also tried an account without MFA protection, same result. Is. there anything In regards of Azure «restrictions» we need to check or change?

There’re no restrictions and MFA is not a problem.

There’s any way to contact you directly and make a remote session to see directly what’s happening?

Sorry for my delay, I was out of office for a few days.

Yes, this would be nice, if you have the time I would like to do a remote session.
How should we organize?

Send an email to jordi.sune@microsoft.com and confirm me your availability 🙂

@adminph-de I have an idea about what is happening, it’s something related with the error control in Power BI, you have to enter to edit queries and check after every API Call the results. If you have errors and you don’t have a step named remove errors at the applied steps section, the load of all data will fail.

I’ll review all the API calls to insert the error control step to avoid this problems. And to clarify we’re not losing data, we don’t have access to request the data with our access level 🙂

Источник

8

ответов