How to forward data to PowerBI using Service Account function in Neowit

In this article, we will show you the first steps in getting started with PowerBI through the Service Account function in Neowit

By using the Neowit open API documentation, you can send data or information collected in Neowit, to third-party software. Under you can find an example of how to get device information over to PowerBI to use for custom reports. 

1. Copy URL: 

https://app.neowit.io/api/device/v1/device

2.Open PowerBI and choose get data from web under the "get data tab" 

3. Choose advanced settings and type in the following 

Please note if using URL from Swagger: replace dev.neow.it with app.neowit.io

4.  Go to the service account page in app.neowit.io and create a Service account for your PowerBI integration. 

Please note: Remember to enable basic authentication.

5. Add a Service account key and copy the KeyID and Secret

Please note: Secret will only be shown once. Therefore write it down. 

6. Go back to PowerBI and choose the basic for authentication. Paste in KeyID for username and the Secret for password. 

Then click Connect 

7. From here you can load the device list, and then set up your reports using powerBI.

The URL posted in Step 1, is only for getting the device list. To get data for booking or general usage, you need to locate the URL in our development tool (Link here) and then connect it to PowerBI using the steps explained above.