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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024 FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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