Expand Gateway connection, click the arrow under actions.
Click Add to Gateway to the right of the Web gateway.
Copy the URL and paste into the Data Source Name field.
Check the box beside Skip Test Connection. Click Add.
Note: It is very important to skip the test connection .
Add the second data source. Click Add to Gateway to the right of the SQLServer gateway .
Copy the Database name into the Data Source Name field.
For Windows authentication enter a username in the format of domain\user and password for an Active Directory user that has read access to the SCCM database. A service account is recommended (see Appendix A - SCCM DB Reader).
You may also choose Basic authentication and enter a SQL login (see Appendix A - SCCM DB Reader).
Expand Gateway connection, click the arrow under Actions.
In the top Maps to dropdown box select the URL
in the bottom Maps to dropdown select the SCCM database name.
Expand Scheduled refresh and select a refresh frequency.
Note: Most customers refresh data once per day however the limit is eight refreshes per day.
Click on the BI for SCCM workspace.
Go to the Datasets tab.
Under Actions click the Refresh icon.
You have now successfully installed BI for SCCM. Refer to the Administration and/or User guides for next steps.