Is anyone integrating or sending information to Power BI from Qualtrics? If so, how is it going for you. We are using Power BI to do quite a bit of reporting dashboards for our operational teams. It is still in its infancy, but so far so good. I use Vocalize for my CX studies and other on-going studies, but might look at pushing some of my results into Power BI since so many in our organization will be using it regularly.

Hi JenFI do parse data from Qualtrics to Power BI, where I connect and visualize experience from Qualtrics and process data from our SAP/ERP and Adobe/web. The way I get the data from Qualtrics is on an hourly basis by utilizing the Qualtrics webservice (api.qualtrics.com) , we parse that over to our Data Lake (Azure environment) .. From PowerBI we connect to Azure where I then extract the JSON data and build my model within Power BI. In our case, the integration via the Qualtrics webservice automates the responses I get on hourly basis. Meaning that if I create another survey now, it will loop in the survey metadata and its responses automatically in next load. In Power BI I will simply run the same process to extract the new survey into my model. I am pretty sure there are other ways to do this. Maybe even directly from Power BI, but doing this via Data Lake/ Microsoft Azure gives us possibilities to apply rules/machine learning etc. on our Experience data, which can be used in other projects.

Hi JenF, I'm a little late discovering your inquiry, but I though I'd share how we use Qualtrics and Power BI at our organization. Before I begin, I'll start by saying the solution we have developed isn't ideal. The ideal solution would be Power BI directly connecting to Qualtrics via their webservice and bringing in survey responses on a regular basis. As far as I am aware, this is not possible. I have found that using the Qualtrics API to bring survey responses into either Excel or Power BI comes with a few annoying difficulties. The issue with the old API (version 2.5) was that any changes or additions to your survey which created extra columns in your data would often break the query. Also, version 2.5 of the Qualtrics API often failed after too many requests in a certain amount of time. This is difficult for our organization as we need to report our survey results as close to real-time as possible. The issue with the new Qualtrics API (version 3) is that survey responses are broken up into multiple JSON files after a certain number of responses. After a few attempts, I could not figure out a way of building a query in either Excel or Power BI that can bring in multiple JSON files from an API.This is what led me to our current solution... I discovered one of the Qualtrics APIs for contact lists, specifically the "List Contacts" API, can be used to bring an entire Contact List (formerly known as a Panel) into Excel or Power BI using power query. This required me to develop some code which works beautifully. Of course, this is of no use unless your survey results are embedded into your contact list. However, pushing your survey responses to a contact list is possible using the Qualtrics webservice within your survey flow (this is the less than ideal part). This requires you to create embedded data from the responses to each of the questions in your survey, then create a webservice that pushes all that embedded data into the contact list you'd like to report from. Next, you would download your contact list (which now has your survey responses) into either Excel or Power BI using Power Query and the code I developed. From there, you can create all the tables, charts and dashboards your heart desires.I developed this process about a year ago. Since then I have created countless reports and dashboards for our clients with very little issues. If anyone is interested in learning more about this process or if you'd like to use the code I developed to bring contact lists into Excel or Power BI via Power Query, please feel free to contact me.

Power BI | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded