Securing PaaS – Creating PaaS Audit and Compliance Power BI Reports

Synopsis: In this exercise, attendees will learn to utilize the Log Analytics feature of Azure to create Power BI Reports.

Task 1: Export a Power Query formula from Log Analytics

  1. Select Monitor, then select Log Analytics.In the Azure Portal, Monitor and Log Analytics are both selected.
  2. Select All collected data.In Log Analytics, under A few more queries to try, All collected data is selected.
  3. Update the search textbox to be search * | where Type == “SecurityDetection.

    NOTE: If you wanted to see things that were specific from your IP address you can add | where ExtendedProperties contains “X.X.X.X” to the query.

  4. Select the Run button.
  5. In the Log Search dialog, select the Power BI link.In the Log Search dialog box, the PowerBI link is selected.
  6. Select Open, a text document with the Power Query M Language will be displayed.
  7. Follow the instructions in the document to execute the query in Power BI.Instructions for how to execute the query in Power BI display.
  8. Close Power BI.

About engsoon

Eng Soon is a 4-time Microsoft MVP and has nearly 5 years of experience building enterprise system in the cloud.He is also a Certified Microsoft Azure.Eng Soon also have strong technical skills and analytic skill. As a developer, Besides the development task, he also involved in Project Management, Consulting, and Marketing. He has a passion for technology and sharing what he learns with others to help enable them to learn faster and be more productive. He also took part as speaker in many nationwide technical events, such as Conference, Meetup and Workshop. Currently, looking for opportunity in Cyber Security which include Cloud Security and Application Security.

View all posts by engsoon →

Leave a Reply

Your email address will not be published. Required fields are marked *