Power BI Integration with Qualaroo

Microsoft Power BI enables you to visualize data with personalized formatting features, giving you insights into your data analytics, further empowering you to make better business decisions. This integration allows Qualaroo customers on 'Growth' and above plans to push survey feedback into Power BI for in-depth analysis.

Prerequisites:

• Power BI Account

• A Qualaroo Account with access to the Reporting API and valid API credentials (available on app.qualaroo.com/account)

• Office 365

In this article, you'll learn:

1. Generating Web Data Connector URL

2. Integrating Qualaroo With Power BI

 1. Generating Web Data Connector URL

A Web Data Connector URL is unique to a Qualaroo customer account.

To generate yours, you require the API Key, API Secret, and the Survey ID. These are provisioned by the customer's account page (app.qualaroo.com/account).

Here's the standard format for all Qualaroo WDC URLs:

For example, for the API Key 1234, API Secret eebc34567890rtey, and the Survey ID 2341, the corresponding WDC URL would be:

https://1234:eebc34567890rtey@api.qualaroo.com/api/v1/nudges/2341/responses.json?

 2. Integrating Qualaroo With Power BI

Step 1: Logging into Power BI

• Open the Power BI Desktop App
• Log in to your account using your credentials.

Step 2: Importing Qualaroo data into Power BI

• Go to 'Home' in the navigation bar
• Select 'Get data' from the taskbar

Step 3: From the dropdown menu,

• Select 'Web' as your data source
  
  

Step 4: In the pop-up window,

• Click on the 'Basic' radio button.
• Paste the Qualaroo API URL in the box. 
• Click OK to continue.

Step 5: To access web content

• Select 'Basic' on the left-hand side menu and enter your API Credentials (available on app.qualaroo.com/account)
• Enter the API KEY as your user name
• Enter the API SECRET as the password
• Hit the 'Connect' button.

Step 6: After hitting the connect button, the window will close, and in a few seconds, you will see the following:

Depending on the dataset size, this may take a while.

Step 7: After the process completion, you can see the Qualaroo dataset in your workspace. You can modify the dataset accordingly.

That is all about integrating Qualaroo with Power BI.