Integration with Power BI | Startquestion Help Center

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.