By combining Startquestion with Power BI, you can automatically pull data from surveys and feed them into your own reports. This allows you to create dynamic dashboards that update automatically - without having to manually export the data.
The entire process can be done in Power BI Desktop using a simple script in the Advanced Editor. You can find full instructions below.
Open Power BI Desktop
Launch Power BI Desktop.
Select Get Data → Other → Blank Query → click Connect.
3. In the new window, click Advanced Editor.
4. Paste the code below and substitute the appropriate data needed for the connection:
Client_ID and Client_secret can be found in the Webankieta panel under ACCOUNT --> Settings --> Integrations --> Startquestion API (v2).
You can find the survey ID in the panel under the Projects tab, under the title of the survey. Alternatively, you can download the entire list of surveys from your account via API
let
// Configuration
client_id = "YOUR_CLIENT_ID",
client_secret = "YOUR_CLIENT_SECRET",
token_url = "https://auth.startquestion.com/token",
api_url = "https://www.startquestion.com/api/v2/results/single-sheets/YOUR_SHEET_ID",
// Function to get a new token
GetAccessToken = () =>
let
TokenBody = "grant_type=client_credentials&client_id=" & client_id & "&client_secret=" & client_secret,
TokenResponse = Json.Document(Web.Contents(token_url, [
Headers = [#"Content-Type" = "application/x-www-form-urlencoded"],
Content = Text.ToBinary(TokenBody)
])),
AccessToken = TokenResponse[access_token]
in
AccessToken,
// Get token
token = GetAccessToken(),
// Set headers
headers = [
#"Authorization" = "Bearer " & token,
#"Accept" = "application/json"
],
// Call API
source = Json.Document(Web.Contents(api_url, [Headers = headers]))
in
source
5. Click Done, and Power BI will automatically download the data from your survey.