Reply
Frequent Visitor
Posts: 6
Registered: ‎02-20-2017
Accepted Solution

Import SCCMT Template in to Power BI Desktop

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


Accepted Solutions
Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Import SCCMT Template in to Power BI Desktop

Hi @hanwar2,

 

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

 

Regards

View solution in original post


All Replies
Super User
Posts: 2,142
Registered: ‎11-29-2015

Re: Import SCCMT Template in to Power BI Desktop

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

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Import SCCMT Template in to Power BI Desktop

Hi @hanwar2,

 

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

 

Regards

Frequent Visitor
Posts: 6
Registered: ‎02-20-2017

Re: Import SCCMT Template in to Power BI Desktop

Hi Super Computer,

 

Thanks a lot,

 

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

Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Import SCCMT Template in to Power BI Desktop

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.Smiley Happy

 

Regards

Highlighted
Frequent Visitor
Posts: 6
Registered: ‎02-20-2017

Re: Import SCCMT Template in to Power BI Desktop

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.

Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Import SCCMT Template in to Power BI Desktop

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.Smiley Happy

 

Regards