Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've been trying for the longest to figure out how to import survey results from Qualtrics into Power BI using Python. Qualtrics support has given me code and I was told all I needed to do was change the apiToken, surveyId, fileFormat and dataCenter lines below but I have not been able to get this to work:
# Python 3
import requests
import json
import io, os
import sys
import pandas
from pandas.io.json import json_normalize
# Setting user Parameters
apiToken = '[ID]'
surveyId = "[ID]"
fileFormat = "csv"
dataCenter = ‘[Datacenter]’
# Setting static parameters
requestCheckProgress = 0.0
progressStatus = "inProgress"
baseUrl = "https://{0}.qualtrics.com/API/v3/surveys/{1}/export-responses/".format(dataCenter, surveyId)
headers = {
"content-type": "application/json",
"x-api-token": apiToken,
}
# Step 1: Creating Data Export
downloadRequestUrl = baseUrl
downloadRequestPayload = {"format": fileFormat, "compress": False, "useLabels": True}
downloadRequestResponse = requests.request("POST", downloadRequestUrl, json=downloadRequestPayload, headers=headers)
progressId = downloadRequestResponse.json()["result"]["progressId"]
print(downloadRequestResponse.text)
# Step 2: Checking on Data Export Progress and waiting until export is ready
while progressStatus != "complete" and progressStatus != "failed":
print ("progressStatus=", progressStatus)
requestCheckUrl = baseUrl + progressId
requestCheckResponse = requests.request("GET", requestCheckUrl, headers=headers)
requestCheckProgress = requestCheckResponse.json()["result"]["percentComplete"]
print("Download is " + str(requestCheckProgress) + " complete")
progressStatus = requestCheckResponse.json()["result"]["status"]
#step 2.1: Check for error
if progressStatus is "failed":
raise Exception("export failed")
fileId = requestCheckResponse.json()["result"]["fileId"]
# Step 3: Downloading file
requestDownloadUrl = baseUrl + fileId + '/file'
requestDownload = requests.request("GET", requestDownloadUrl, headers=headers, stream=True)
#data = json.loads(requestDownload.content)
#df = json_normalize(data['responses'])
data = requestDownload.content
df = pandas.read_csv(io.StringIO(data.decode("utf-8")))
df
I'm not a developer nor do I have Python experience, so I have no clue what I would need to change to get what I'm looking for. I'm slightly confused because this seems to be code for exporting results to a CSV, but I was hoping to connect straight from Power BI to Qualtrics.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |