Transform Lakehouse JSON File to Table: There was a problem refreshing the dataflow

[LiveEngage]

Hi all,

When I tried to create a Dataflow Gen2 that reads data from JSON files in my Lakehouse and write the two resulting tables into new tables I am trying to create in the same lakehouse, I receive an error message. It still fails when I run the dataflow separately or from within data factory.

The data preview in the data flow looks good, I have chosen the destination tables (new) and didn't receive any errors.

Error in manual separate run:

Error when running via Data Factory:

Any help is appreciated!

[mrojze]

Hi there,

how do you even read a JSON file from the Lakehouse.

I called an API and saved the JSON file in the files section of the Lakehouse. I can't find a way to ready this file now.

Can you shed some light for me? 🙂

Thanks!

[miguel · Accepted solution]

Could you please check the following thread and see if any of the suggestions provided by Pablo apply to your case?

Solved: Re: Dataflow Gen2 Web.Contents : Error : PowerBIEn... - Microsoft Fabric Community

Best!