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.
Impactful Individualhi 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
Post Partisanlucadelicio - Is there a way we can achieve this using API as I tried to enable API for a user account.