Forum Discussion
Post PartisanConnect Qualtrics to Power BI
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.
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.
Post PartisanAnonymous - Is there a way we can achieve this using API as I tried to enable API for a user account.
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?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
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.
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.