kohera-logo-regular.svg

How To video: Visualise your Fitbit data in Power BI

In this video, our BI wizard Frederik Aerts, integrates the data of his Fitbit into Microsoft Power BI.

When using the template, you need to provide the full path of 3 example files (steps/calories/resting heart rate) and also the main folder path:

  • Folder: this is the folder where your downloaded Fitbit data resides (unzipped)
  • FullPathSteps: this is an example file for the Steps (pick any json file you want from the Folder above, as long as it starts with `steps`)
  • FullPathCalories: this is an example file for the Calories (pick any json file you want from the Folder above, as long as it starts with `calories`)
  • FullPathHearRateRest: this is an example file for the Resting Heart Rate (pick any json file you want from the Folder above, as long as it starts with `resting_heart_rate`)

For example:

If your system is not using the US date format, you will probably see this error after loading the data:

In that case, go to `File > Options and settings > Options` and set the regional settings for import to English (United States):

That should do it!

Group of computer programmers working in the office. Focus is on blond woman showing something to her colleague on PC.
Updating your Azure SQL server OAuth2 credentials in Power BI via PowerShell for automation purposes
The better way to update OAuth2 credentials in Power BI is by automating the process of updating Azure SQL Server...
2401-under-memory-pressure-featured-image
Under (memory) pressure
A few weeks ago, a client asked me if they were experiencing memory pressure and how they could monitor it...
2402-fabric-lakehouse-featured-image
Managing files from other devices in a Fabric Lakehouse using the Python Azure SDK
In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding...
2319-blog-database-specific-security-featured-image
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
kohera-2312-blog-sql-server-level-security-featured-image
SQL Server security made easy on the server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
blog-security_1
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...