Power BI

That said, I would be happy to hear your thoughts on how you plan to visualize CX in Power BI and I can share what how our V1 looks like? :-) Let me know if you''d like to catch-up on Skype.

I am just getting started with PowerBI and also want to bring in my survey data from Qualtrics. Does anyone have a solution that avoids going through something like the Azure environment listed above?

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.

> @J_Alvarez1 said: > I am just getting started with PowerBI and also want to bring in my survey data from Qualtrics. Does anyone have a solution that avoids going through something like the Azure environment listed above? Hi @J_Alvarez1 , see my post above re: Qualtrics data and Power BI. Feel free to reach out if you'd like some additional explanation.

@Matt : Hi Matt, i would love to get more details here. Thanks

> @GSSCEAGAppManBD said: > @Matt : Hi Matt, > i would love to get more details here. > > Thanks Hi @GSSCEAGAppManBD, feel free to send me a private message describing the specific details you'd like.

Has anyone requested that Qualtrics develop an integration / connector with Power BI so that we can vote this up?

> @Tim said: > Has anyone requested that Qualtrics develop an integration / connector with Power BI so that we can vote this up? You suggest this in the NEW IDEAS area of the community board if you are able.

What is the path to get to the New Ideas area of the community board?