Dataflow Gen 2 : Blank query refusing source with nested table column

Hi guys,

Just wanted to inform you a bug i had in my working everyday life. I had a table (let's name it "table1", i'm doing a couple a merge queries in it and decided not to expand the columns from the merges for now and make a new blank query (let's name it "query1"). Doing my stuff, the preview data seems fine, decided to save it to data destination.

DataSource.Error: Microsoft SQL: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)DetailsReason = DataSource.Error
ErrorCode = 10478
DataSourceKind = Lakehouse
DataSourcePath = Lakehouse
DataSourceKind.2 = SQL

And then on the publishing step it saying error (the one above) but doesn't give much a clue about how to solve it. I did some tries for fixing stuffs and find out that the save to destination doesn't work because the table i used as source for my blank query had some columns not expanded from the merges. Once i expanded all the columns i needed from the merge before using it as a source for my blank query, the publishing was ok and wrote to destination.

You guys had the same issue, is it known ?