Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

What is the best way to connect Qualtrics to Microsoft PowerBI?

AdamK12
AdamK12 Bethesda, MDCommunity Member, XMPN Member, XMPN Champion, Qualtrics Brand Admin Superuser ✭✭✭✭

We have just received Microsoft PowerBI as an enterprise visualization tool and I've been exploring the use cases. It's easy to connect flat files downloaded from Qualtrics, but I'm wondering if there are better ways of creating connections that can be automatically or manually refreshed. It looks like the only available web connector in Qualtrics is for Tableau. I've seen documentation that suggests using the API, but are there any other approaches (particularly for non-coders like me)? Thanks in advance!

Best Answers

  • ahmedA
    ahmedA IndiaCommunity Member, XMPN Member Wizard ✭✭✭✭✭
    Accepted Answer

    Unfortunately Microsoft's Graph API while well documented, isn't really that popular with the open source community and hence it's difficult to find pre built connectors for Power BI.

    IMHO there are two options that you can consider, both may require some coding but not much. Use an automation tool like Tray.io or Zapier, you'll need to push your data from Qualtrics to a storage like S3 or Google drive and then setup Power BI to update at regular intervals. Alternatively, you could also look at a data pipeline tool like panoply.

  • AdamK12
    AdamK12 Bethesda, MDCommunity Member, XMPN Member, XMPN Champion, Qualtrics Brand Admin Superuser ✭✭✭✭
    Accepted Answer

    Thanks, @ahmedA -- we also use Google BigQuery as an analytics, storage, and ETL tool so I would imagine we could explore that as an option.