Skip to content

Challenge-03.md

Latest commit

 

History

History
34 lines (24 loc) · 2.18 KB

Challenge-03.md

File metadata and controls

34 lines (24 loc) · 2.18 KB
Raw

Challenge 03 - Create the Realtime Reporting

< Previous Challenge - Home

Pre-requisites

  • Stock Table in the KQLDB
  • KQL Queryset with transformations

Description

You've been tasked with creating some real time reporting using Power BI based on the data that is constantly being generated every second. In this challenge, you must bring in the data from the KQL database/queryset to PowerBI. You need to create visualizations that represent the incoming data, but you will also need to modify some settings to ensure that this is truly real-time reporting.

Success Criteria

To complete this challenge, verify that:

  • You have a PowerBI report displaying the data from the Stock table.
    • Line Graph showing the previous minute of data of each stocks price
  • Your report page is auto-refreshing every second with the data your KQL DB is ingesting continuously.

Learning Resources

Tips

  • Use a Card that has the count of the number of records to help ensure data is being constantly updated in the report.
  • To get to the Fabric capacity settings you can go to the Admin Portal in Power BI and then on the far right click on Fabric Capacity. In there the Automatic page refresh setting should be under Power BI Workloads
  • To create the settings for realtime reporting, make sure you are clicked off of any visuals so that the page settings show up.
  • It is easier to save the report in the popout from the KQL Queryset, then open it in the proper editor in the browser, rather than in the small popout from the KQL Queryset option.

Additional Challenges

  • Get creative with the Power BI report! What kind of visuals can you create?