Forum Discussion
How to merge multiple JSON files into one
Assuming you have two json files with same structure and you want to parse and append them as a table in Fabric. There are multiple ways to do this task, one of the qucik and easy way is through dataflow (gen 1 or gen 2, depending on your usecase).
Move these two josn files into a Lakehouse folder and create a new dataflow and connect to the lakehouse and combine the files.
You can follow these intructions: https://www.youtube.com/watch?v=Nbhd0B5ldJE
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Hi tharunkumar,
But the video looks like we need to merge it from PowerBI Desktop, doesn't it ? by using Power Query ?
Can we do that inside Fabric ?
Can we do it in the pipeline ? is there merge feature in there ? If I look into Data Factory, there is Union feature, but can't find in Fabric. I was also thinking probably need to merge using notebook, and merge in within using Python code.
Thanks