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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
arkiboys2
Helper IV
Helper IV

reading json file

hello,

using the ADF dataflow, I use the flatten activity to read the json file...
How can I do this in fabric?

thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @arkiboys2 ,

Thanks for using Fabric Community.
I tried to upload JSON file into DataFlow Gen 2 and here is my result,

Sample Json:

[
    {
        "id": 1,
        "items": [
            {
                "name": "Headphones",
                "price": 79.99,
                "quantity": 1
            },
            {
                "name": "Notebook",
                "price": 9.99,
                "quantity": 2
            }
        ],
        "customer": {
            "name": "Alice Smith",
            "address": {
                "street": "10 Main St",
                "city": "Anytown",
                "state": "CA",
                "zip": "98765"
            },
            "phone": "555-123-4567"
        }
    },
    {
        "id": 2,
        "items": [
            {
                "name": "T-Shirt",
                "price": 14.99,
                "quantity": 1
            },
            {
                "name": "Mug",
                "price": 5.99,
                "quantity": 1
            },
            {
                "name": "Pen Set",
                "price": 3.49,
                "quantity": 2
            }
        ],
        "customer": {
            "name": "Bob Jones",
            "address": {
                "street": "25 Elm St",
                "city": "Springfield",
                "state": "NY",
                "zip": "10001"
            },
            "phone": "555-567-8901"
        }
    }
]

 
Uploading Json File into Dataflow Gen 2:

vgchennamsft_1-1718877206962.png



Output in Dataflow Gen 2:

vgchennamsft_0-1718877070027.png


You can find each and every operation/steps it performed at right corner.

Can you please upload your json file into dataflow gen2? 

Hope this is helpful. Please let me know incase of further queries.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @arkiboys2 ,

Thanks for using Fabric Community.

I’d recommend connecting to the JSON directly in Dataflow Gen2 to perform the flatten operation if it just a single file.

 

If there are multiple or it’s a large file, I’d suggest looking at the Copy activity in Data pipeline to land it into the lakehouse and then Dataflow Gen2 to connect and flatten.

Hope this is helpful. Please do let me know incase of further queries.

yes the files are in the storage account.

how can I flatten the data in dataflowgen2? there is no flatten activity.

thank you

Anonymous
Not applicable

Hi @arkiboys2 ,

Thanks for using Fabric Community.
I tried to upload JSON file into DataFlow Gen 2 and here is my result,

Sample Json:

[
    {
        "id": 1,
        "items": [
            {
                "name": "Headphones",
                "price": 79.99,
                "quantity": 1
            },
            {
                "name": "Notebook",
                "price": 9.99,
                "quantity": 2
            }
        ],
        "customer": {
            "name": "Alice Smith",
            "address": {
                "street": "10 Main St",
                "city": "Anytown",
                "state": "CA",
                "zip": "98765"
            },
            "phone": "555-123-4567"
        }
    },
    {
        "id": 2,
        "items": [
            {
                "name": "T-Shirt",
                "price": 14.99,
                "quantity": 1
            },
            {
                "name": "Mug",
                "price": 5.99,
                "quantity": 1
            },
            {
                "name": "Pen Set",
                "price": 3.49,
                "quantity": 2
            }
        ],
        "customer": {
            "name": "Bob Jones",
            "address": {
                "street": "25 Elm St",
                "city": "Springfield",
                "state": "NY",
                "zip": "10001"
            },
            "phone": "555-567-8901"
        }
    }
]

 
Uploading Json File into Dataflow Gen 2:

vgchennamsft_1-1718877206962.png



Output in Dataflow Gen 2:

vgchennamsft_0-1718877070027.png


You can find each and every operation/steps it performed at right corner.

Can you please upload your json file into dataflow gen2? 

Hope this is helpful. Please let me know incase of further queries.

Anonymous
Not applicable

Hi @arkiboys2 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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