Integrating OMS and Power BI

cover.png

This Blog shows you how easy it is to Integration OMS with Power BI. OMS solutions are a great way to visualize data and Power BI has built a fantastic set of data visualization tools, so you can unlock some pretty powerful scenarios by using OMS as a data source.

On Portal OMS, Go to Settings > Preview Features, and set the Power BI Integration switch to Enabled

 

4

 

Go to Settings > Accounts > Workspace Information, and select Connect to Power BI Account

5

 

Sign in with your Power BI credentials.

6

7.PNG

 

For export our data to Power BI. Go to Log Search from the main page. Type Type=Event and press Enter to search.

10.PNG

 

Select PowerBI as seen in the following picture. on Power BI Form use current search quary, give name, and dataset name

11.PNG

 

This take up to 10 minutes before the dataset is created in Power BI Go to the Settings and select Power BI.

13.PNG

 

Go to PowerBI.com, and sign in with your Office 365 account. After you´re logged in, select the menu  button (Menu button.) to bring out this view

14.PNG

 

I want to do is to create a diagram containing information of events log. Select the Pie Chart model, and then check EventLevelName and EventID as seen in the following screenshot.

15

 

Drag EventID to Values , Drag Computer to visual level filters. In this case, I want to show only one computer in my report.

16.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the format icon (the pencil) to the right, turn on Legend, choose Right center , and give it an appropriate name.

17

 

On Data Colors and choose color for each data , and give it an appropriate name.

18

 

On Title choose color ,  give it an appropriate name, and set aligment to center.

19

 

Turn on Background and set color for background.

20.PNG

 

Okay for Pie Chart has Finished, right now i want create a diagram containing information of Event Log Description. Select the Table model Visualizations, and then check EventLevelName , EventLog, EventID ,and Message  as seen in the following screenshot.

21

 

Drag Computer to visual level filters as seen in the following screenshot.

22

 

Select the format icon (the pencil) to the right, On Values and set color for font and background.

24.PNG

 

Turn On Title, give it an appropriate name, choose background color and set aligment to center.

25

 

Turn On Background, choose background color and set Transfarency .

26.PNG

 

On Column headers, choose background and font color For Column Headers .

27.PNG

 

Save and enter a name for report.

29

 

You will see result on Report page and click your report30b.PNG

 

On report if you click Log error on top diagram then on table show description for Event Level Error only

30a.PNG

 

Thank You 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s