Power BI Connector

The Power BI Connector allows you to connect your QuestionPro survey directly to Power BI Desktop to create interactive dashboards and visualizations without the need for manual data exports.

With this connector you can:

• Pull survey response data directly into Power BI.
• Choose whether to import all responses or only completed responses.
• Select your preferred header display type.
• Select your preferred answer display type.
• Refresh your data anytime within Power BI.

Before setting up the integration, ensure you have:

• An active QuestionPro account with license - Research Edition.
• An active Power BI Desktop license.
• Your QuestionPro API key and Survey ID.
• Knowledge of your QuestionPro data center (US, EU, CA, etc.).
• A stable internet connection to fetch data from QuestionPro.
• Permissions to install connectors on your system.

1. Log in to your QuestionPro account.
2. Navigate to Integration tab.

3. Click on Power BI integration tile.

4. Click QuestionPro.mez file to download the file.

1. Download QuestionPro.mez.
2. Open your file browser (File Explorer on Windows or Finder on macOS).
3. Navigate to your Power BI folder:
• Windows: C:\Users\{YourUsername}\Documents\Power BI Desktop\Custom Connectors. Replace {YourUsername} with your actual username.
• macOS: /Users/{YourUsername}/Documents/Power BI Desktop/Custom Connectors. Replace {YourUsername} with your actual username.
4. If the Custom connectors folder doesn’t exist, create it manually.
5. Move QuestionPro.mez into the Custom connectors folder.
6. Relaunch Power BI — you’ll now see the QuestionPro Connector in the Connect pane.

To connect your QuestionPro survey to Power BI, follow the steps below:

• Open Power BI and click on Get data from other sources.

• Search for QuestionPro, select the connector and then click on Connect.

• Enter your Data Center (US, EU, CA, etc.).
• Enter your Survey ID.
• Choose Response Type. Enter 0 for Completed responses only. Enter 1 for All responses (includes Completed + Started).
• Choose Answer Format. Enter 0 for answer code format. Enter 1 for answer text format.
• Choose Header (Question) Format. Enter 0 for question code format. Enter 1 for question text format. Then click OK.

• Enter your API key to proceed.
• The import process will start and you'll see an option to load data. Click on Load data to import data into Power BI.

Can’t connect to QuestionPro?

• Verify your API Key is correct.
• Ensure you have selected the correct Data Center (US, EU, CA, etc.).
• Confirm your internet connection is stable.
• If using a corporate network, check if a firewall or proxy is blocking Power BI from connecting to QuestionPro servers.
• Restart Power BI after making any configuration changes.

Missing data fields?

• Ensure the survey has at least one response, empty surveys will return no data.
• Check if you selected the correct Answer Display Type (coded values vs full text).
• Verify you have chosen the correct Response Type (completed responses only vs all responses).
• If changes were made to the survey structure, refresh the Power BI extract to sync fields.

Connector not appearing in Power BI?

• Confirm the QuestionPro.mez file is in the correct Custom connectors folder for your OS.
• Ensure you are running a Power BI version that supports custom connectors.

Data refresh is slow

• Filter the data within Power BI to reduce the volume of records being loaded.
• Use Completed Responses Only if partial data is not required.
• Ensure your network speed meets Power BI’s recommended bandwidth for live data connections.

I am not able to see my QuestionPro API key, how do I generate the API key?

• If you cannot see you QuestionPro API key on the Power BI Connector screen then please click here to learn about generating the API key.

I am not sure on which datacenter(DC) I am on, how do I find my datacenter?

• Datacenter can be found under My Account dropdown. Click here to know more.