![]() One last step needs to be done in order for the data to populate.Once downloaded, open the SolutionTemplate.pbix file, it will open in Power BI Desktop.Once the process is completed, you can download the Power BI SCCM Dashboard by clicking on Download Report.The initial synchronization pulls data out of Configuration Manager database and pushes the data into the specified SQL Database Review your choices, enter your email address if desired to receive information about Power BI and click Run.On the Customize pane, select the time you wish to have your scheduled task to be run and the desired Compliance Target number, click on Validate and Next.The 5,6,7 and 8 steps will be automatically skipped.If you are using Azure SQL (which is unlikely for an SCCM installation), check the Using Azure SQL box.On the Target pane, select your SQL Server, click on Validate, select your Database from the drop-down then Next.In the Source pane, enter your SCCM server name, click on Validate, select your Database from the drop-down then Next.These credentials will also be used to run a Powershell script on a recurring schedule. On the Login pane, Enter your credentials to connect to the SCCM database.The installation wizard will launch in new window, click Next.This will download the SCCM-Template.exe file.Once back on the Getting Started pane, click on the Download button.On the Business Platform Solution Template screen, click Accept.The Office 365 portal pops-up, select your work email account and enter your credential if you’re not already logged-in.On the Getting Started pane, click Sign In.We will now download and configure the Power BI integration Wait for the process to finish and close the installation wizard.Select the Installation Directory and click Next.Accept the license terms and click Next.Download Power BI Desktop from the Microsoft download center.We will start by installing Power BI Desktop: At the end of the process, the Template file (Dashboard) will be available to download and use. ![]() The installation wizard will get us through the process of entering the information about our SCCM, SQL Server and/or Azure environment in order to establish a connection for Power BI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |