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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

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

Top Solution Authors
Top Kudoed Authors