Forum Discussion
Solved
Loaded a JSON file in OneLake... Now what?
Hi there, I successfully called an API and saved a JSON file in the Files section of the Lakehouse. Now, I am trying to read the file and unpack the datasets inside. I'd love to use the Dataflows ...
Hi,
You can do it using a pipeline and the copy activity, you can even using the copy assistant to help you building it.
The dataflows can't be used for this.
The pipeline needs to be in the same workspace as the lakehouse, but it will ask you if your source is the "Files" or "Tables" area. The Dataflow Gen 2, on the other hand, doesn't need to be in the same workspace, but only accepts the "Tables" area as source or destination.
Kind Regards,Dennes
Hey!
Have you tried using the Lakehouse connector and the "Files" section inside of it to access the files from your Lakehouse?
If not, please give it a try and let us know if it works for you.