Click "Get Data" in Power BI and use the OData protocol. Enter your OData URL and use the Basic method to access the database. Note: you will need to contact your Weever CS rep to get an Access Key.
Step 1: Get your Access Key
To connect Power BI to Weever Process you will need to first request an Access Key from your Weever Customer Success (CS) Rep. Simply email them to request the Access Key. They will then set up a meeting with you to provide it to you verbally, as we do not share Access Keys openly though the internet, via email or messaging applications. If you do not know your CS rep, you can email your name and site along with your request to the following email address: customersuccess@weeverapps.com.
Note: you will also require "Administrator-level" permissions for your email to be used as the User Name in the Basic connection protocol with Power BI.
It is critical that you paste your access key in a secure location.
For security purposes, you will only be allowed to see or copy the access key from Weever the first time you generate it. For this reason, it is critical that you paste your access key in a secure location so you can reference it later as you need it (ie. when you set up a scheduled refresh in Power BI web you will need the same access key).
Each Weever account can only have one active access key at a given time. If you lose your access key, you can generate a new one, but that will revoke the previous access key and therefore break the live connection from Weever to any Power BI reports you've created. It will not affect reports created by others in your organization. When you generate a new access key, just re-enter your email and the new access key in any live Power BI reports or scheduled refresh instances so your reports will continue to get live data.
Step 2: "Get Data" via OData protocol in Power BI
Once you have your app's Access Key, log into Power BI and click "Get Data".
Then click on "OData Feed".
For the URL, enter in the following where "appslug" is replaced by the prefix (subdomain) of your Weever app.
https://appslug.pm.weeverapps.com/v1/odata/v1/process
For example, if your Weever app's URL is mycompany.weeverapps.com, then your OData feed URL is: https://mycompany.pm.weeverapps.com/v1/odata/v1/process
Step 3: Add your username and access key
Tap "Basic" and enter email address you use to login to Weever in the User Name field. Now you will have to get your access key you were provided by your Weever Customer Success Representative. The Access Key is your "Password" when connecting using the Basic method in Power BI.
Step 4: Choose your form(s) and/or users
From the list of forms tap the checkbox beside the form(s) you want to load into Power BI and tap "Load".
And that's it!
Now you can connect your Weever Process data to Power BI.