Installation et configuration du tableau de bord SCCM Power BI (Exprimer).
Contenu
The template is free to download. A Power BI SCCM Dashboard provides high level overview of key SCCM metrics.
SCCM Power BI Dashboard Prerequisites
- Centre système 2012 Configuration Manager R2 SP1 (5.00.8239.1000) ou plus tard. Read access to System Center Configuration Manager database is required.
- Destination database: Azure SQL database or SQL Server database (Serveur SQL 2008 R2 SP3 or later).
- For the machine where the installation is run,
- Microsoft .NET Framework 4.5 ou plus tard.
- PowerShell version 5.0 ou plus tard.
- For Operating System: Serveur Windows 2008 R2 SP1, ou plus tard. Fenêtres 7 Professional, Entreprise, ou plus tard. Note that Windows 10 anniversary update (1607 ou plus tard) is not supported at this moment because of a bug in credential guard.
SCCM Power BI Dashboard Installation and Configuration
The SCCM Power BI solution template download has been moved to GITHub. You will find two templates. Download the one that you require and copy to target location.
- SCCMSolutionTemplate.pbix
- SCCMSolutionTemplateAS.pbix
SCCM Power BI Tableau de bord Configuration
1. Open copied template file (SCCMSolutionTemplate.pbix) with Power BI Desktop;
2. Sign in to Power BI;
3. On the menu bar, cliquez Edit Queries puis cliquez Data source settings;
4. Cliquez Change Source and enter your sccm server and database;
5. Cliquez Edit permissions et cliquez Modifier. Enter username which has rights to database.
6. Cliquez Fermer et cliquez Apply Changes;
7. Ready;
Salut,
I did try this configuration and it is loading with Errors. When I click Refresh button, it says Load was cancelled by an error loading previous table.
Salut, try this full solution: https://enterinit.com/sccm-install-and-configure-power-bi-dashboard/
Bonjour, this doesn’t work. will get error on all field expect STSqlServer and STSqlDatabase.
“The key didn’t match any rows in the table”
Here’s an example
Expression.Error: The key didn’t match any rows in the table.
Details:
Key=
Schema=pbist_sccm
Item=site
Table=[Table]
Malheureusement, this PBI template is useless as it no longer work with recent version of SCCM
Salut. Essayez ceci https://enterinit.com/sccm-install-and-configure-power-bi-dashboard/ steps.