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. 

For this integration, you require Office 365 other than Power BI and Qualaroo accounts.

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:
https://[API KEY]:[API SECRET]@api.qualaroo.com/api/v1/nudges/SURVEY_ID/responses.json?

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 Power BI With Qualaroo
Step 1. On your Power BI dashboard, go to ‘Get data’ and click ‘Web.’

Step 2. Paste in your Web Data Connector URL under the Basic section and click Ok to proceed.

Step 3. Under the Basic section, type in your username and password. Your username is the API Key, while the password is the API Secret. Then, click 'Connect' to establish a connection between your Qualaroo and Power BI accounts.

Once the connection is established, you’ll start receiving Qualaroo data sets on your Power BI dashboard, such as the landing pages URLs, survey IDs, referral sites URLs, date & time, etc.

We hope this information has been helpful. For any questions or additional help, please feel free to reach out to us at support@qualaroo.com.