Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

Dataflows
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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