Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SVVIS
Frequent Visitor

DataFlow Gen2 with destination to Lakehouse creates strange tables

Hi to everyone

 

I'm a first timer with Data Factory though i'm pretty experienced with PowerBI power Query. 

 

So i've created a dataflow gen2 that takes data from On-prem SQL server, prepares those into tables and loads to the destination of Lakehouse. Once executed I find on lakehouse not only those tables that I've ordered to create as a result of DataFlow execution but others with crazy letter-numerical names but with contents of those other tables i've ordered to create... what goes wrong?

 

THanks for support

1 ACCEPTED SOLUTION

looks like the problem was resolved by using another Lakehouse as a destination point. The new lakehouse is created by myself, while previous was created by my colleague. In  new LH the problem is not present. DataFlow Gen2 remains all the same except having another LH as a destination point. HOpe it helps you to find a bug. If I can help you somehow, I'm available.

 

Sergey

 

View solution in original post

6 REPLIES 6
SVVIS
Frequent Visitor

found out that all of those are having parquet word in name... probably those are technical tables that should be created? Then the question is which one should I use to create a data model (star scheme) for PowerBI report?

Anonymous
Not applicable

Hi @SVVIS ,

Thanks for using Fabric Community.
Can you please share few screenshots with source tables and destination tables?
I need few more details regarding your ask inorder to guide you better.

Hi

Here are some screenshots of what you ask me (I hope I understood you well, but let me know if more or else is needed) 

 

Much appreciated,

Sergey 

image.pngimage.pngimage.pngimage.png

Anonymous
Not applicable

Hi @SVVIS ,

Can you please share screenshots like this?

vgchennamsft_0-1707385147970.png

 

vgchennamsft_1-1707385249679.png

 

vgchennamsft_2-1707385268632.png

 

Tables at my lakehouse -

vgchennamsft_3-1707385300701.png

 



When I tried to reproduce your scenario, I am able to get 3 different tables without any issue.
I just want to know what is the step that created those parquet tables.


looks like the problem was resolved by using another Lakehouse as a destination point. The new lakehouse is created by myself, while previous was created by my colleague. In  new LH the problem is not present. DataFlow Gen2 remains all the same except having another LH as a destination point. HOpe it helps you to find a bug. If I can help you somehow, I'm available.

 

Sergey

 

Anonymous
Not applicable

Hi @SVVIS ,

Glad to know that your query got resolved by changing it with new Lakehouse.
I am happy to guide you with your query. Please continue using Fabric Community for your further queries.

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

Expanding the Data Factory Forums

New forum boards available in Data Factory

Ask questions in Apache Airflow Job and Mirroring.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.