Try It
Print

Configure The Dataset Parameters

Copy the URL link to this section to share

The BI for SCCM dataset contains some parameters that must be configured in order to synchronize data from ConfigMgr to Power BI. Other parameters add additional functionality to BI for SCCM. In this article we will only configure the parameters required for basic functionality. Optional parameters are discussed in other articles within our documentation. 

Step

  1. Select Workspaces.
  2. Select the BI for SCCM workspace.
(click to enlarge)
Step

  1. Hover over the bi_for_sccm Semantic model to reveal a kebab menu (three vertical dots).
  2. Select the kebab menu.
  3. Select Settings.
sccm semantic model
(click to enlarge)
Step

  1. Expand Parameters.
  2. Enter the API Key that you received from us after completing the Request a Trail Key form.
  3. The Computer Network IP Address Enable fields accepts TRUE/FALSE values. This field controls whether or not IP Addresses from ConfigMgr inventory are sync'd to Power BI or not. 
  4. Enter the ConfigMgr database name in the DatabaseName field.
  5. Enter the Server name of the SQL Server hosting the ConfigMgr database in the ServerName field.
  6. The Software Is Used Days(s) value is the number of days that installed software must have been used within for the reports to show Is Used = True. 
  7. The Software Update Not Required Status Enable field accepts 
  8. TRUE/FALSE values. This field controls whether or not software updates required by no computers are displayed in Power BI. It's strongly recommended to leave this value as FALSE. 
  9. Select Apply.
(click to enlarge)
Step

  1. Expand Gateway Connection.
  2. Under Actions, expand the toggle button to view the data sources.
  3. Select the Add to gateway link for the SQL Server data source.
(click to enlarge)
Step

  1. On the Data Source Settings page enter the following.
  2. For the Data Source Name enter a meaningful name to identify this data source.
  3. For the Data Source Type select SQL Server.
  4. Enter the SCCM SQL Server name in the Server field. 
  5. Enter the SCCM SQL database name in the Database field.
  6. Select Windows as the Authentication Method. 
  7. Enter database reader user account in the Username field. If this is an Active Directory user account you must prefix the username with the domain name and a "\". Do Not Use the "@" sign plus domain name. 
  8. Enter the password for the database reader account in the Password field.
  9. Select Add.
(click to enlarge)
Step

  1. Select Workspaces.
  2. Select the BI for SCCM workspace.
(click to enlarge)
Step

  1. Select Datasets + dataflows.
  2. Hover over the bi_for_sccm dataset to reveal a kebab menu (three vertical dots).
  3. Select the kebab menu.
  4. Select Settings.
(click to enlarge)
Step

  1. Expand Gateway Connection.
  2. Under Actions, expand the toggle button to view the data sources.
  3. Select the Add to gateway link for the SQL Server data source.
(click to enlarge)
Step

  1. Expand Parameters.
  2. In the Maps to drop-down menu in the SqlServer source select the SQL Server data source that you created in Step 5.
  3. Ignore the warning that your data source can't be refreshed.
  4. Select Apply.
  5. Select Edit credentials. 
(click to enlarge)
Step

  1. Select Anonymous as the Authentication Method.
  2. Select Organizational as the Privacy level setting for this data source.
  3. Select Sign in.
(click to enlarge)
Step

  1. Expand Scheduled refresh.
  2. Select Add another time.
  3. Enter up to eight times of the of the day for the data to refresh. Depending upon the environment, most customers select 1-3 times per day.
  4. Grab something cold to drink, you made it through configuring the dataset. The refresh can take anywhere from 5 minutes to 2 hours depending upon your environment. On average, it's about 30 minutes.
(click to enlarge)
Step

  1. Select Workspaces.
  2. Select the BI for SCCM workspace.
(click to enlarge)
Step

  1. Select Datasets + dataflows.
  2. Hover over the bi_for_sccm dataset to reveal the Refresh now button.
  3. Select the Refresh now button.
  4. Grab something cold to drink. You've made it through configuring the dataset. The refresh will take anywhere between 5 minutes and 2 hours depending on the environment, however the average is about 30 minutes.
(click to enlarge)