Forum Discussion

TePe's avatar
TePe
Icon for Helper IV rankHelper IV
2 years ago
Solved

Can't create a Lakehouse destination

Hi,   I tried to take the WWI Data Sample (used a Copy Activity in a Pipeline to bring the dimensions and facts into the Lakehouse) and do some transformations on top of the fact table. However, fi...
Need Help
  • TePe's avatar
    TePe
    2 years ago

    I get closer to the solution, if I find some time I'll try to replicate... It looks that the problem appears when you don't have any meaningful transformation in the Dataflow. Meaning: just add a source and try to add a destination and then the problem appeared for me. As soon as I added a transformation I could add the destination successfully. But as I said, I need to replicate that again... And in my case the Dataflow ran for more than 1 hour for the WWI fact table (about 50mio records, just reading the records without transformation but with staging enabled, no destination) which I think is REALLY slow...

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

I just experienced the spinner circling forever as well just now after creating a Data destination. My setup is different than yours. Nonetheless, I did a page refresh, and the issue went away.  What went away also was the query in the dataflow and I had to recreate it from scratch.  So always a good idea to backup all your query M code somewhere local, just in case.