Simple SQL query that runs 7 seconds in SQL takes 19 minutes(!) to validate in Dataflows 19 minutes!!!??? Not just one query. I've tried SQL Server and PostgreSQL - the time it takes to Validate i...
Just want to chime in, I'm waiting several hours for validation of dataflows that take only a few minutes to refresh. Very difficult to manage when any change involves such a monster time sink.
What's strange is that if I copy the queries into a Power BI desktop transform, they process and populate quickly without any of this nightmare black hole...so I know it's avoidable.
It is certainly disappointing that Microsoft does not care enough to even comment on such a huge waste of our time. This is a tremendous downside for using dataflows.