Power Platform Dataflows | Merge Queries

[@Topness]

This was a fantastic demo! Worth another watch.

[@andreapinillos]

Thanks, Phil!

[@TheBatis10]

You are amazing, always a video for anything I am working on, thank you Andrea.

[@andreapinillos]

Glad it was useful!

[@danielpenrod6472]

Very Informative. Thanks for sharing.

[@andreapinillos]

Thanks for watching!

[@RajanPatel-cc4xg]

Thanks this really helped me

[@MyNameIsDr]

Since you know both options. What would you prefer "Power Platform Dataflows" vs "Azure Data Factory"?

[@rafaelapinillos6]

So informative and detailed!

[@derek_shannon]

Wow, this may be just what I needed at exactly the right time, but I'll have to try and see--Wondering whether this technique would get many-to-many relationships going? Thank you, Andrea! ;-D

[@andreapinillos]

You are very welcome!

[@gilleshellin7326]

Thank you!

[@sreekanthreddyu]

Thanks for this video and its informative and useful, small suggestion please speak loud or use head phone, I can't able to hear your voice.

[@josephlim2064]

HI Andrea, is it possible to achieve the same with just one dataflow instead of two? What should be done to make sure that the Dataflow inserts into the HR_Person table before the Person table since the latter depends on the former? Thanks

[@andreapinillos]

Yes, it is possible. You have to ensure the main table comes first in the hierarchy and the enable load setting in the sub-table is switched off. Then at the publish stage, ensure the sub-table data load is switched to “do not load”.

[@陳志偉-z6s]

Thanks