Power BI Desktop ➡ Direct Query | SQL Server | Real-Time Simulation | every second | Fitbit Data‼
In this video, we will use SQL Server & Power BI Desktop to create a report page that refreshes every second and has several interactive visuals.
Dataset is from my Fitbit watch Charge 5 (csv file)
https://drive.google.com/file/d/1MtjY...
TIMESTAMPS
00:00 Intro and purpose of this video
01:02 Overview of the fitbit dataset
01:18 Using SSMS create a database
01:37 Import flat file into this database
02:25 Create a sql script and test scenarios
04:00 From PBI desktop connect to SQL Server
04:20 Get data & Use Direct Query data connectivity mode
05:14 In a Report page change enable Auto refresh to 1 second
06:24 Review the measures that are needed for report page
08:13 Overview of Dashboard report page
08:24 Recap and Conclusion