Skip to content
Custom Connector for Power BI to connect with the Oura smartring Cloud API
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
OuraCloudConnector
.gitattributes
.gitignore
OuraCloudConnector.sln
OuraStats.ps1
README.md

README.md

Oura Cloud Connector

This is a Custom Connector for Power BI to access Oura's Cloud APIs.

Why is a custom connector needed?

In order to retrieve Oura's data from their API you'll need to authenticate successfully through their OAuth2 API. This requires a client ID and a client secret, that in turn result in an access token. Using this access token queries can be executed against the API. This custom connector takes care of handling the tokens and authorization, and provides a clean and easy interface for retrieving and analyzing your own health data in Power BI.

For details on how this connector was built and how to use it, see my blog article here.

Using the connector

In order to use this connector, you'll need to first install the Power Query SDK for Visual Studio from the Visual Studio Marketplace. This allows you to edit and build the connector specifics.

Next, open the project in Visual Studio and modify client_id.txt and client_secret.txt. These are the OAuth2 authorization values you'll get from Oura's own Cloud API. Compile the solution, and deploy the resulting .MEZ file to %USERPROFILE%\Documents\Power BI Desktop\Custom Connectors.

Start up Power BI Desktop, select Get Data and select OuraCloudConnector. This allows you to query the Oura API directly. See Oura's own API documentation for the exact parameters.

Contact

PRs are more than welcomed. For any additional comments, send me a DM via Twitter.

You can’t perform that action at this time.