O'Reilly logo

Microsoft System Center Reporting Cookbook by Samuel Erskine, Dieter Gasser, Kurt Van Hoecke, Nasira Ismail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to System Center data sources with Power Query

Using the Power Query add-in, you can connect to data from different sources. SQL Server databases, Azure SQL databases, OData feed, different file formats, and many others are available as data sources in the POWER QUERY tab on the Excel ribbon. Once connected, you can merge functions, integrate them, and perform other manipulations on data from these sources to meet your analytical requirements.

Getting ready

Chapters 4 to 8 of this book provide information about data sources for reporting. You can use the same sources as the input for your Power BI queries.

You must have a fully deployed and functioning System Center 2012/R2 Service Manager Data Warehouse to complete this recipe. The following ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required