Power BI Integration - sheaphillips/common-hosted-form-service GitHub Wiki

Home > CHEFS Capabilities > Integrations >Power BI Integration

Microsoft Power BI is one of many ways to work with form submission data. The web version of Power BI doesn't have the features needed to retrieve submissions, so download Power BI from the Microsoft Store.

Power BI Query

By creating a new Power BI query you can work with the submission data.

CHEFS Form Information

You will need this information about your form:

  • The formId and formVersionId. One way to retrieve them is to "Manage" your form and in the table at the bottom click "Version 1" (or the version you want). The URL in the new browser window will contain ".../preview?f={formId}&v={formVersionId}"
  • Your form's API Key

Query Configuration

  • In the ribbon at the top of Power BI click Get data and select Web
  • Use the URL https://submit.digital.gov.bc.ca/app/api/v1/forms/{formId}/versions/{formVersionId}/submissions to get the submissions for a version of your form - you will need to replace {formId} and {formVersionId} with the values for your form
  • Choose "Basic" for the authorization type, with "User name" set to your formId and "Password" set to your API Key