All

Build PowerBi Dashboard based on Intune Data Warehouse

jannikreinhard16 Comments

The Intune Data warehouse provides some data that is very useful for creating reports. In this blog I will show you how to access this data with PowerBi and also provide you with a example dashboard.

What is the Intune data warehouse

The Intune data ware house is a collection of multiple structured data tables with relations. You can use these for reporting purposes. It uses the OData model and you can access both daily and historical data. The Intune data warehouse only shows Intune devices, co managed devices have to be retrieved via ConfigMan. You can find the OData feed string in the Mem Portal under Reports -> Data warehouse.

Usefull linkes:

Install PowerBi Desktop on your device

Access the Intune Data Warehouse in PowerBi

  • Open PowerBi Desktop
  • Select Get data
  • Search for Intune Data Warehouse and click Connect
  • Select Don’t warn me again for this connector and click Continue
  • Select the history you want to have and click OK
  • Click Sign in and authenticate with your account
  • Click Connect
  • Select the Tables you need for the reporting

Import read to use Dashboard

  • Sign in with your credentials
  • Have fun with the dashboard

App View

Device view

Config Profile

Conclusion

With this dashboard you get a high-level overview of your environment. You can extend it with other data sources or expand it further and customize it for your needs (you don’t have to take care about the design).

Stay healthy, Cheers
Jannik

11.02.2023: Error 0x80040E4E

If you got this error you have to change the regional setting: https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

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

  4. 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?

    Like

    • 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″}

      Like

Comments are closed.