Try It
Print

Dataset Parameters Explained

Copy the URL link to this section to share

The BI for Intune dataset contains some parameters that must be configured in order to synchronize data from Intune to Power BI. Other parameters add additional functionality to BI for Intune. This article explains each of the parameters in detail.

Step

  1. To view or modify the dataset parameters select Workspaces.
  2. Select the BI for Intune workspace.
(click to enlarge)
Step

  1. Hover over the bi_for_intune Sematic model to reveal a kebab menu (three vertical dots).
  2. Select the kebab menu.
  3. Select Settings.
intune model settings
(click to enlarge)
Step

  1. Expand Parameters.
(click to enlarge)
Step

ApiKey

  1. Required configuration: Yes
  2. Default value: Blank
  3. This should be the API Key that you received from us after completing the Request a Trial Key form.
(click to enlarge)
Step

AzureAD ClientID

  1. Required configuration: Yes
  2. Default value: blank
  3. The Application (client) ID from the Azure AD App Registration.
(click to enlarge)
Step

AzureAD ClientSecret

  1. Required configuration: Yes
  2. Default value: Blank
  3. The Azure AD Client Secret is the most common mistake that customers make when installing BI for Intune.  It is shown as the "Value" when adding the client secret to the Azure AD App Registration. The Client Secret does not have dashes (-) in it. The Client Secret looks similar to this: iB9GT~dZg.F.AKvxzMzjk7T1kIzlFocEh4JXcgI
(click to enlarge)
Step

AzureAD Compliance Policy Setting State Enable

  1. Required configuration: None
  2. Default value: TRUE
  3. This parameter disables the synchronization of Configuration Profiles of the Settings Catalog type. It is TRUE, meaning that the results of those profiles are sync'd to Power BI. This parameter was added due to periodic issues in a small number of Azure data centers that caused synchronization failures. Leave at the default value unless instructed otherwise by PowerStacks support.
(click to enlarge)
Step

AzureAD Compliance Policy Setting State Enable

  1. Required configuration: None
  2. Default value: TRUE
  3. This parameter disables the synchronization of Configuration Profiles of the Settings Catalog type. It is TRUE, meaning that the results of those profiles are sync'd to Power BI. This was parameter was added due to periodic issues in a small number of Azure data centers that caused synchronization failures. Leave at the default value unless instructed otherwise by PowerStacks support.
(click to enlarge)
Step

AzureAD Disk Max Read Errors

  1. Required configuration: None
  2. Default value: 100
  3. Used to calculate disk health. Default value is based upon the Microsoft MSFT_StorageReliabilityCounter class documentation. 
(click to enlarge)
Step

AzureAD Disk Max Wear

  1. Required configuration: None
  2. Default value: 90
  3. Used to calculate disk health. Default value is based upon the Microsoft MSFT_StorageReliabilityCounter class documentation. 
(click to enlarge)
Step

AzureAD Disk Max Write Errors

  1. Required configuration: None
  2. Default value: 100
  3. Used to calculate disk health. Default value is based upon the Microsoft MSFT_StorageReliabilityCounter class documentation.
(click to enlarge)
Step

AzureAD Export URL

  1. Required configuration: None
  2. Default value: Blank
  3. The export URL varies from one Azure tenant to another. If this value is not populated our code will find the correct URL that your Intune environment uses to export data, however, to avoid redirection and improve security it is recommended to set this parameter.
  4. Be sure to also set AzureAD Export URL Enable = TRUE when using this parameter.
  5. To learn more please see our Configure Intune Export API documentation. 
(click to enlarge)
Step

AzureAD Export URL Enable

  1. Required configuration: Yes, only if the AzureAD Export URL has been populated.
  2. Default value: FALSE
  3. Determines if the URL from the AzureAD Export URL is used or if the URL is found automatically by the app. 
  4. Setting this parameter to TRUE will create a new data source credential that must be configured.
    1.  Authentication method: Anonymous
    2. Privacy Level: Organizational
    3. Check "Skip test connection"
(click to enlarge)
Step

AzureAD Export URL Timeout (s)

  1. Required configuration: None
  2. Default value: 3600
  3. Determines the amount of time the sync process waits for each Intune export job before it times out. Do not change this value unless instructed to do so by PowerStacks support.
(click to enlarge)
Step

AzureAD Export URL Wait (s)

  1. Required configuration: None
  2. Default value: 1
  3. Determines the amount of time the sync process waits for each Intune export job to report a status and then loops until a status is received. Do not change this value unless instructed to do so by PowerStacks support.
(click to enlarge)
Step

AzureAD Group Dynamic Members Only

  1. Required configuration: None
  2. Default value: TRUE
  3. When set to TRUE only members of dynamic groups will be available in the reports. Changing this to FALSE will make members of assigned groups available in the reports. However, getting the members of assigned groups is a more intensive process and might cause synchronization timeouts. 
(click to enlarge)
Step

AzureAD Group Members Enable

  1. Required configuration: None
  2. Default value: TRUE
  3. Determines whether or not the members of Azure AD groups are available in the reports. Depending upon the number of Azure AD groups this could cause synchronization failures.
  4. By default, group members of dynamic groups are available in the reports however this can be modified by the AzureAD Group Dynamic Members Only parameter.
(click to enlarge)
Step

AzureAD LogAnalytics Day(s)

  1. Required configuration: None
  2. Default value: 30
  3. Allows you to configure the number of days of data to pull from Log Analytics.
(click to enlarge)
Step

AzureAD LogAnalytics Enable

  1. Required configuration: Yes, only for our customer inventory solution and/or Windows Update for Business reports (formerly named Azure Update Compliance v2.)
  2. Default value: FALSE
(click to enlarge)
Step

AzureAD LogAnalytics PageSize API

  1. Required configuration: None
  2. Default value: 10000
  3. Determines the page size of Log Analytics queries. Do not change this value unless instructed to do so by PowerStacks support.
(click to enlarge)
Step

AzureAD LogAnalytics WorkspaceID

  1. Required configuration: Yes, only for our custom inventory solution and/or Windows Update for Business reports (formerly named Azure Update Compliance v2.)
  2. Default value: Blank
  3. This is the workspace ID of the Log Analytics workspace where the custom inventory and/or Windows Update for Business Reports data is stored. 
  4. When using our custom inventory solution and Windows Update for Business Reports both must store data in the same Log Analytics workspace.
(click to enlarge)
Step

AzureAD Pace API (s)

  1. Required configuration: None
  2. Default value: 0
  3. Determines the amount of time the sync process waits for a response from the Pace API's and then it loops until a response is received. Do not change this value unless instructed to do so by PowerStacks support.
(click to enlarge)
Step

AzureAD PageSize API

  1. Required configuration: None
  2. Default value: 10000
  3. Determines the page size for MS Graph queries. Do not change this value unless instructed to do so by PowerStacks support.
(click to enlarge)
Step

AzureAD Sign-Ins Day(s)

  1. Required configuration: None
  2. Default value: 1
  3. By default, only sign-in data from the last 1 day are available in the reports. Getting more days of sign-in data will result in slower synchronizations and possibly cause synchronization timeouts. The max value is 7.
  4. Note, sign-in data can be completely disabled by setting this value to -1.
(click to enlarge)
Step

AzureAD Sign-Ins Failure Only

  1. Required configuration: None
  2. Default value: TRUE
  3. Determines whether or not successful sign-ins are available in the reports. By default, failed sign-in data are available in the reports. Getting successful sign-in data will result in slower synchronizations and possibly cause synchronization timeouts. 
(click to enlarge)
Step

AzureAD TenantID

  1. Required configuration: Yes
  2. Default value: Blank
  3. This should be your Azure AD tenant ID. 
  4. Note: An easy way to get this is to go to https://www.whatismytenantid.com/
(click to enlarge)