First I would like to mention that if you don’t need connectivity to On Premise data you can sign up for a free Power BI account read more about it here.
Before you can jump into building these reports you will need to configure the Service Level Target (SLT) and Service Level Objectives (SLO) in SCOM here is a good walk through by Kevin Green of how to configure the SLT and SLO.
Part 1 – Setting up the data for our dashboard
In December Microsoft released a preview version of the new Power BI Designer they are building. This new tool will make it easier to get data into a report. You can see this improvement already in the preview here is a screen shot of some of the data sources you can select from.Continue reading
In the last blog post in this series I covered how to install the Power BI – Data Management Gateway, now that you have the gateway setup we are ready to create a data source.
From the Power BI admin center web page go to data sources and click the plus sign to start the new data source wizard.
You can download the Data Management Gateway here or when you create your gateway in the Power BI admin center. Version 1.2.5303.1 was release in July 2014 added support for:
· scheduled data refresh for Power Query data connections with the following data sources: File (Excel, CSV, XML, Text and Access), Folder, IBM DB2, My SQL, Sybase, SQL Azure, PostgreSQL, Teradata, Sharepoint List, OData Feed, Azure Market Place, Azure HDInsight, Azure Blob Storage and Azure Table StorageContinue reading