topic Re: Transform Lakehouse JSON File to Table: There was a problem refreshing the dataflow in Dataflow

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

Anonymous — Thu, 01 Jun 2023 15:30:12 GMT

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!

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

miguel — Thu, 01 Jun 2023 18:03:54 GMT

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!

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

mrojze — Fri, 18 Aug 2023 15:31:06 GMT

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!