Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
iBusinessBI
Kudo Collector
Kudo Collector

Is it possible to save the results of a Query as a JSON file?

I am pulling data from REST API source.
One of the Columns in the Query invokes a function with an API call.

I would like to save this step as a JSON file AS-IS, without having to "expand" this column (that contains Records) to columns.
Is it possible with Dataflows Gen2? Maybe save to Lakehouse as a file but not as a table?

Currently, when I choose Lakehouse as a source, it only prompts me for a Table name and says:

"A new table will be created in Lakehouse"

I need to save a JSON file, not a table. And I want to use the Dataflow, not Data Factory.

Please help

1 ACCEPTED SOLUTION
miguel
Community Admin
Community Admin

Dataflows Gen2 doesn't have a way to save the binary as is today. I encourage you to to post your idea to make this feature available in Dataflow Gen2 from the link below:

https://aka.ms/FabricIdeas

 

However, it is possible to query a REST API with pipelines and save the results as a binary using Pipelines. You can use the copy activity for it:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn 

View solution in original post

3 REPLIES 3
miguel
Community Admin
Community Admin

Dataflows Gen2 doesn't have a way to save the binary as is today. I encourage you to to post your idea to make this feature available in Dataflow Gen2 from the link below:

https://aka.ms/FabricIdeas

 

However, it is possible to query a REST API with pipelines and save the results as a binary using Pipelines. You can use the copy activity for it:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn 

Thanks, @miguel 

I am not talking about saving a binary, but a simple JSON/text file.

I did open an idea, please vote:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b9b321af-be2a-ee11-a81c-000d3a0ec312

 

Thank you for posting the idea!

 

Basically at its core the file is considered a binary and then you can define what extension such file / binary might have or how it might be interpreted or how it should be encoded.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Fabric Update Carousel

Fabric Monthly Update - September 2025

Check out the September 2025 Fabric update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors