Best answer by TomG
View original
How to use the Qualtrics API in conjunction with Power BI?
+1
I've been doing research for a long time now and I see no clear way on how to connect Power BI and Qualtrics through the Qualtrics API. What I'm aiming to do is automate the process of importing survey results into Power BI. Currently I just have a spreadsheet that I manually add new survey results to as they come in. I got instructions on how to do it with the 2.5 version which seemed easy, but I've been advised to stay away from that now and do it the v3 way. The v3 way makes 0 sense to me and seems not possible to directly connect to Power BI.
This is super easy to do with an API. Allows automated Power BI updates once imported.
Try this as a web CSV import -
https://YOUR DATA CENTER ID.qualtrics.com//WRAPI/ControlPanel/api.php?API_SELECT=Co ntrolPanel&Version=2.5&Request=getLegacyResponseData&User=USER ID&Token=TOKEN HERE&Format=CSV&SurveyID=SURVEY ID
HERE&Labels=1
Your data center ID is in the root URL.
The root URL for communicating with the Qualtrics system is:
https://yourdatacenterid.qualtrics.com/WRAPI/ControlPanel/api.php
Like M in Power Query? Here's the code, just copy a table and replace its code with the following:
let
Source = Csv.Document(Web.Contents("https://co1.qualtrics.com//WRAPI/ControlPanel/api.php?API_SELECT=ControlPanel&Version=2.5&Request=getLegacyResponseData&User=USER ID&Token=TOKEN HERE&Format=CSV&SurveyID=SURVEY ID HERE&Labels=1"),[Delimiter=","]),
#"Removed Top Rows2" = Table.Skip(Source,1),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows2", [PromoteAllScalars=true])
in
#"Promoted Headers"
Try this as a web CSV import -
https://YOUR DATA CENTER ID.qualtrics.com//WRAPI/ControlPanel/api.php?API_SELECT=Co ntrolPanel&Version=2.5&Request=getLegacyResponseData&User=USER ID&Token=TOKEN HERE&Format=CSV&SurveyID=SURVEY ID
HERE&Labels=1
Your data center ID is in the root URL.
The root URL for communicating with the Qualtrics system is:
https://yourdatacenterid.qualtrics.com/WRAPI/ControlPanel/api.php
Like M in Power Query? Here's the code, just copy a table and replace its code with the following:
let
Source = Csv.Document(Web.Contents("https://co1.qualtrics.com//WRAPI/ControlPanel/api.php?API_SELECT=ControlPanel&Version=2.5&Request=getLegacyResponseData&User=USER ID&Token=TOKEN HERE&Format=CSV&SurveyID=SURVEY ID HERE&Labels=1"),[Delimiter=","]),
#"Removed Top Rows2" = Table.Skip(Source,1),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows2", [PromoteAllScalars=true])
in
#"Promoted Headers"
+1
I've been having issues with trying to do it this way. I just always get an error message saying it can't find the user.
Userlevel 7
+27
@RCBIZMarketing,
Users who used version 2.5 of the API prior to it being deprecated got grandfathered in. Any other users don't have access to that version. You'll probably have to use the new API (which requires more steps).
Users who used version 2.5 of the API prior to it being deprecated got grandfathered in. Any other users don't have access to that version. You'll probably have to use the new API (which requires more steps).
+1
Thanks Tom. I was unfortunately told that as well by the support team. Not familiar with Python but this seems to be the only way to do this now.
Userlevel 7
+27
> @RCBIZMarketing said:
> Thanks Tom. I was unfortunately told that as well by the support team. Not familiar with Python but this seems to be the only way to do this now.
You can use any web based script (python, php, etc.).
> Thanks Tom. I was unfortunately told that as well by the support team. Not familiar with Python but this seems to be the only way to do this now.
You can use any web based script (python, php, etc.).
Here is an alternative way to connect to PowerBI without coding https://wxwr.medium.com/syncing-qualtrics-survey-results-to-excel-and-powerbi-using-power-automate-f0cafebeb466
+1
https://community.qualtrics.com/XMcommunity/discussion/comment/14024#Comment_14024I can't login, I believe this is due to my login to qualtrics happening via SSO, does anyone have a solution for this?
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.