Importing Data to Fabric Lakehouse using DF Gen2 on Tables with _ creates temporary Tables

[RoRtm]

We use the On-Prem Data Gateway to get Data from an On-Prem SQL Server in a Dataflow Gen 2 top store tables in the Azure Lakehouse. When having Tables containing an "_" in the name (e.g. ABTEILUNG_T) it results in strage table structure on the Lakehouse:

Expeted here would be ABTEILUNG_T, AKTIVITAET_T only.

As soon as i get rid of the "_" in the dataflow query settings -> Name. It works.

Renaming worked for us, but should be fixed

[GeethaT-MSFT · Accepted solution]

Hi @RoRtm Thanks for posting your question in Microsoft Fabric Community

This is weird behavior, I will report this to the internal team and provide you with more details.

Regards

Geetha  

[GeethaT-MSFT · Accepted solution]

Hi  @RoRtm As per the internal team, The DataflowsStagingLakehouse is an internal lakehouse used by Dataflows.  It will eventually be hidden.

Please let me know if you need any additional information,

Regards

Geetha

[GeethaT-MSFT · Accepted solution]

Hi @RoRtm Thanks for posting your question in Microsoft Fabric Community

This is weird behavior, I will report this to the internal team and provide you with more details.

Regards

Geetha