Build PowerBi Dashboard based on Intune Data Warehouse

13 thoughts on “Build PowerBi Dashboard based on Intune Data Warehouse”

1. The dashboard looks nice but when I try to refresh the data I get the following error:
   OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
   I think it’s related to Regional settings but I can’t find a setting that allows the data connection to complete. Any thoughts?

   • It looks like that this is an issue with the encoding and an strange character. Can you give me more details from this error message. You can also check this: https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/m-p/116683

     Can you try this: https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

   • Sorry, I overlooked your reply. Just had a chance to review your response and test a few things. I enabled tracing and grabbed the error from the logs. Here is the error, which doesn’t mention language support or unusual characters.

     DataMashup.Trace Error: 24579 : {“Start”:”2023-02-18T18:09:45.7086982Z”,”Action”:”PBI.TraceMessage”,”sessionId”:”xnxnxnxnxnxnxnxnxnx”,”deviceId”:”xnxnxnx”,”userId”:”xnxnxnxnxnxnxnxnxnx”,”isInternal”:”False”,”authenticatedUserId”:”xnxnxnxnxnxnxnxnxnx”,”Message”:”ASOperationException with failed queries in ApplyQueriesToModel.Details:Type=Microsoft.AnalysisServices.OperationException, Message=Failed to save modifications to the server. Error returned: ‘Column ‘platform’ in Table ‘mamApplicationInstances’ contains a duplicate value ‘3’ and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
     OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
     The current operation was cancelled because another operation in the transaction failed.
     ‘., ASErrorCode=3241541694|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904|3239837702|3238395904|3238395904|3238395904|3238395904|3238395904|3238395904, StackTrace=at Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl
     at Microsoft.PowerBI.Modeler.ModelManager.c__DisplayClass248_0.b__0
     “,”ProductVersion”:”2.114.664.0 (23.02)”,”ActivityId”:”00000000-0000-0000-0000-000000000000″,”Process”:”PBIDesktop”,”Pid”:38872,”Tid”:104,”Duration”:”00:00:00.0000175″}

2. Same error here: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

   • It looks like that this is an issue with the encoding and an strange character. Can you give me more details from this error message. You can also check this: https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/m-p/116683

     Can you try this: https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

3. Same error

4. Same Error as welll – hmmmm – any ideas?
   OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

   • It looks like that this is an issue with the encoding and an strange character. Can you give me more details from this error message. You can also check this: https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/m-p/116683

5. Its a bit weird since it seems to generate the error based on the intune tenant not from where the report is runned? Both are running from power bi desktop latest version.

   This tenant works:

   Tenant location
   Europe 0202
   MDM authority
   Microsoft Intune
   Account status
   Active
   Service release
   2301

   This one does not:

   Tenant location
   Europe 0601
   MDM authority
   Microsoft Intune
   Account status
   Active
   Service release
   2301

   More details of the errors:

   enrollmentActivities
   Column ‘dateKey’ in Table ‘enrollmentActivities’ contains a duplicate value ‘20230130’ and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

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

   • Did you saw my comment on the bottom of the blog how to fix 0x80040E4E. Did this hel?

   • I only see à reference to change regional settings but from What? And What to?

   • You have to change the Region in PowerBi to solve your issue. The regional settings are the problem with the character support. Know this is a bit confusing but it helps. Check this:
     https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/m-p/116683

6. hmm ive tried from Us to german .. same, keeps working for the tenant above that works but same errors for the one that did not work :/

Comments are closed.