cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LiveEngage
Regular Visitor

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

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:
 
LiveEngage_3-1685633291872.png
 
Error when running via Data Factory:
 
LiveEngage_4-1685633311272.png

Any help is appreciated!

 

1 ACCEPTED SOLUTION
miguel
Community Admin
Community Admin

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!

View solution in original post

2 REPLIES 2
mrojze
Helper I
Helper I

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
Community Admin
Community Admin

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!

Helpful resources

Announcements
Fabric August Update Carousel

Fabric August 2023 Update

Check out the August 2023 Fabric update to learn about new features.

Data Factory Founders Badge

Data Factory Community Founders Badge

Become a founding member of the Data Factory Community.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Data Factory Webinar Series Sept

Join the Data Factory Webinar series!

Want to learn more about Data Factory in Fabric? Join our webinars this month to build up your Data Factory skills!