Connect Qualtrics to Power BI

[POSPOS]

Hi All,

I have a requirement to connect Qualtrics Survey details in Power BI. Can someone suggest how this can be achieved. I tried connecting using API as per the blog   but was not successful as API is not enabled for my account. Is there any other way this can be achieved?

Thank you.

[SanazDolatkhah0]

Hello,
I developed an automation that reads Qualtrics survey results, questions, and translations, stores the data in a SQL Server, and generates a Power BI template.

[baybay_creator]

How were you able to do this?

[SanazDolatkhah0]

I have used Qualtrics API and Python to read data and store it in SQL Server.

[baybay_creator]

Thank you for replying Sanaz, could you give more details on your solution?

[SanazDolatkhah0]

I have shared a simplified and smaller version of this Qualtrics Integration with SQL Server on my GitHub repository. You can take a look there, and if you have any further questions, I’d be happy to stay in touch.
Github link:
https://github.com/SanazDolatkhah/Qualtrics_Integration_With_SQLServer

[foodd]

@POSPOS ,  have you thought about creating a new thread in the Qualtrics Community Forum? The Qualtrics Community is active and responsive. If you still need to register, please do so and then follow the link below to start a new thread. 

https://community.qualtrics.com/topic/new

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

cc:  @Anonymous , @lucadelicio 

[Anonymous]

Hi @POSPOS ,

Thank you for @lucadelicio answer, and I have other suggestions for you:

Use an automation tool like Tray.io or Zapier, you'll need to push your data from Qualtrics to a storage like S3 or Google drive and then setup Power BI to update at regular intervals. 

Below is the link will help you:

What is the best way to connect Qualtrics to Microsoft PowerBI? | XM Community

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[POSPOS]

@Anonymous  - Is there a way we can achieve this using API as I tried to enable API for a user account.

[Anonymous · Accepted solution]

Hi @POSPOS ,

Yes, if you have API account and we could use Qualtrics API to get data and import data to Power BI Desktop.

Please have a good look at this blog about how to use the Qualtrics API.

Here is a post about how to use Rest API as Datasource in Power BI.

Or you can refer to this blog about syncing Qualtrics survey results to Excel and PowerBI using Power Automate.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[POSPOS]

Hi @Anonymous   - 
From the blog ,  Can you please advise on  how can we get the URL mentioned in point 4 ?
Also in point 10, what values should given? 

[Anonymous]

Hi @POSPOS ,

In the point 4: the url is the URL of the API request, which can usually be found in the API Documentation.

Below is the link will help you:

Using Qualtrics API Documentation

Web Service (qualtrics.com)

In the point 10: These values ​​are custom.You’ll want to use Piped Text for values with dynamic data, such as First Name, Last Name, and Email.

Piped Text (qualtrics.com)

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lucadelicio]

hi @POSPOS ,
the way i saw in a big project was to create a datawarehouse in wich you have to insert all the rows of the survey.
Then you can analyze it with PowerBi.

So for example import the json output in sql database with Azure pipeline.
Then create on sql the table that you need and import all the tables in PowerBi to create the model.

I hope i will help you.

Bye

[POSPOS]

@lucadelicio  - Is there a way we can achieve this using API as I tried to enable API for a user account.