How to use the Qualtrics API in conjunction with 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"

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.

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.

> @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.).