{"id":11110,"date":"2020-04-30T01:51:50","date_gmt":"2020-04-30T05:51:50","guid":{"rendered":"https:\/\/www.eginnovations.com\/blog\/?p=11110"},"modified":"2022-08-24T03:24:43","modified_gmt":"2022-08-24T07:24:43","slug":"microsoft-power-bi-integration","status":"publish","type":"post","link":"https:\/\/www.eginnovations.com\/blog\/microsoft-power-bi-integration\/","title":{"rendered":"Integrating eG Enterprise with Microsoft Power BI for Application and Infrastructure Performance Analytics"},"content":{"rendered":"

<\/span>What is Microsoft Power BI?<\/span><\/h2>\n

\"Power<\/a>Microsoft Power BI<\/a> is a business analytics solution providing interactive visualizations and business intelligence capabilities from data and provides an interface that is simple enough for admins to create their own reports and dashboards. Data inputs to Power BI can come from multiple sources \u2013 Excel worksheets, CSV files, database tables, log files, the web, etc. It then employs smart visualizations and built-in AI technologies on that data to turn it into interactive insights.<\/p>\n

eG Enterprise is<\/a> a converged application and infrastructure performance monitoring solution that collects hundreds of thousands of performance metrics across every layer and every IT tier. Users of eG Enterprise are looking for different ways to visualize the performance data collected by it. While the built-in reporting console in eG Enterprise offers a wide variety of reports, administrators may still want to analyze and present the data in different ways. This is where Microsoft Power BI can be used.<\/p>\n

This blog discusses how Microsoft Power BI can be integrated with eG Enterprise and how administrators can use the integration to get new perspectives on IT performance, thus empowering them to make intelligent and well-informed performance\/business decisions.<\/p>\n

<\/span>eG Enterprise v7 now supports integration with Power BI<\/span><\/h3>\n

\"eG<\/a>You can run queries on the Oracle\/Microsoft SQL server backend of your eG installation to extract data from it and then convert the data into a format that Power BI supports \u2013 eg., CSV, XLS, JSON, XML. The smarter alternative is to use the eG Enterprise Command Line Interface (CLI). You can install the lightweight eG CLI<\/a> software on any Unix\/Windows host in your environment and quickly configure it to connect to the eG manager.<\/p>\n

Using the CLI, you can then run commands on the manager to pull any type of data \u2013 be it raw measurement data, trend data, and even threshold data \u2014 from the eG backend and save it as a CSV \/ XML \/ TXT file, which can then be ported to Power BI. Power BI is also built with specialized connectors, which allow you the flexibility to connect to any data source directly from the Power BI Desktop and pull the data you want from it.<\/p>\n

\"BI<\/a>Once the data you need is available on the Power BI Desktop, you can use the editing tools that Power BI provides to transform the data to suit your needs. For instance, you can remove columns you do not want from a database table, pull data from other tables, sort the data, and so on. This way, you can play around with the extracted data, so that it is in a form that can be used to generate the report that you desire. Then, using Power BI\u2019s reporting\/visualization engine, quickly build the performance reports you want.<\/p>\n