Forum Discussion

prathyoo's avatar
prathyoo
Advocate II
3 years ago

Power BI Legacy Dataflow vs Dataflow Gen2 performance

Hi,   We have an existing Power BI Legacy Dataflow with around 69 tables as follows -       We replicated this to Dataflow Gen2 in order to write all the power queries to lakehouse tables...
Need Help
miguel's avatar
miguel
Community Admin
3 years ago

Hey!

One other way to move your dataflows from Gen1 to Gen2 is using th Export template feature:

Move queries from Dataflow Gen1 to Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

 

I don't think that we have sufficient information to provide any suggestions in terms of improving your queries, but I highly suggest reaching out to the support team by creating a support ticket so they can take a closer look at the scenario.

 

One workaround is to load the data to something like the Lakehouse and then do the append after the tables are in the lakehouse, but it would add an extra step.

  • prathyoo's avatar
    prathyoo
    Advocate II
    3 years ago

    Thanks. I am not sure whether to reach out to support as yet. The fabric workspace is still a trial capacity. The power query works fine in the legacy dataflow taking only 15 seconds and the same seems to have gone on for more than 2 hours before I had to kill the refresh.

     

    I will raise the issue if the smae still exists after our premium capacity has moved to fabric.