Qualtrics Curated Data to Fabric Lakehouse

[jbauer22]

Hey Fabricators!

Has anyone successfully integrated Qualtrics curated data to a lakehouse?  There are edits and rule logic in Qualtrics that is applied.  We do not want to apply the same rules in the data pipeline to our Fabric lakehouse.  Has anyone found a way to integrate the data after it has been curated in Qualtrics to Fabric?

[v-prasare]

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.

[v-prasare]

@jbauer22,

As we haven't heard back from you, reaching out to check if there is any progress on above ask? 

Thanks,

Prashnath Are

MS Fabric community support

[jbauer22]

1. Data Extraction is done via Qualtrics API , notebook for transformation and orchestration via Fabric data pipeline.

2. Yes. "curated date" = recodes, filters and multiple data sources shown together in one dashboard.

3. Qualtrics API

[v-prasare]

Hi @jbauer22,

As of now there are no one implimented the use case that you have mentioned above. Can you please eloborate your requirements so that i can guide you here.

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare]

Hi @jbauer22,

I hope you're doing well. I wanted to follow up on our previous discussion to check if your query has been resolved. Please let me know if you still need any help or if there's anything further I can assist you with.

Looking forward to your response!

Thanks,

Prashanth Are

MS Fabric community support.

[v-prasare]

Hi @jbauer22,

Just to clarify and better assist:

• Could you please share how you're currently integrating Qualtrics with Fabric? Are you using APIs, Dataflows Gen2, Azure Data Factory, or some other method?

• When you mention “curated data” in Qualtrics, are you referring to data that’s modified via filters, rules, or dashboard transformations within Qualtrics?

• Are you currently exporting this curated output manually (e.g., via PDF/CSV) or looking for an automated pipeline that brings only the post-processed logic-driven data into Fabric?

thanks,

Prahsnath Are

MS fabric community support

[jbauer22]

1. Data Extraction is done via Qualtrics API , notebook for transformation and orchestration via Fabric data pipeline.

2. yes. recodes, filters and multiple data sources shown together in one dashboard.

3. correction: we are only importing raw data at this time.

[v-prasare · Accepted solution]

Hi @jbauer22,

To bring in curated Qualtrics data, already enriched with recoded values, filters, and combined views. you can use the Qualtrics Reporting API or Export Reports API. These APIs let you export data that reflects the same logic applied in your dashboards, giving you much more than just raw survey responses.

Once exported (typically as a CSV, Parquet, or JSON file), you can bring the data into Microsoft Fabric using several tools. If the export is saved to OneDrive or SharePoint, you can use OneLake Shortcuts to directly link those files into your Lakehouse. Alternatively, you can automate the data fetch using a Notebook—connect to the Qualtrics API, download the curated file, and load it into a Lakehouse table or ingest it using Dataflow Gen2.

Since the data already includes all business logic from Qualtrics, only light transformation (like column renaming or formatting) is required. Once the data resides in the Lakehouse as a Delta table, you can build your Power BI Semantic Model directly on top, enabling reporting without the need to recreate any complex dashboard logic within Fabric

Thanks,

Prashanth Are