Import SCCMT Template in to Power BI Desktop

[hanwar2]

I have downloaded SCCMT Template on my latop and I am using Power BI desktop, please let me know how to import the SCCMT template on my Power BI Desktop. 

I want to create a dashboard for SCOM Exchange environment

[v-ljerr-msft · Accepted solution]

Hi @hanwar2,

Here is an article which describes how to set up SCCM Power BI solution template step by step for your reference.

Regards

[hanwar2]

Hi Super Computer,

Thanks a lot,

Could you please help me with steps for SQL server which is on premise and not in Azure.

[v-ljerr-msft]

Hi @hanwar2,

You only need to create the blank database(for Target) in SQL Server by using SQL Server Management Studio or Transact-SQL instead of in Azure. The rest steps should be the same.

Regards

[hanwar2]

Hi Super Contributor,

I am also using SCOM for monitoring exchange environment, is there any solution wherein I can create dashboard in Power BI for the SCOM related alerts and metrics.

[v-ljerr-msft]

Hi @hanwar2,

Though there is no solution template for SCOM currently, you should be able to use Power BI Desktop to Create Reports from System Center Operations Manager yourself. Here is a good article for your reference.

Regards

[Phil_Seamark]

There is a demo here that you can get some tips from.