Forum Discussion

VoltesDev's avatar
VoltesDev
Helper V
2 years ago

How to merge multiple JSON files into one

Hi,   I have 2 JSON file with the same structure. May I know what is best to merge it ?  These is just a JSON file from "bing seach" result, only with different market. Are we doing it in d...
Tutorial Requests
tharunkumarRTK's avatar
tharunkumarRTK
Super User
2 years ago

VoltesDev 

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



 

  • VoltesDev's avatar
    VoltesDev
    Helper V
    2 years ago

    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