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...
pdbenbow
Resolver II
Resolver IIv-chuncz-msft's response to the post is exactly the same one he/she gave to this post 3 months ago about the exact same issue: PBI dataflows validating for a VERY LONG TIME!!! - Microsoft Power BI Community
It would be nice if we could get the support team to take this matter seriously instead of refer us to documentation that does not address the true nature of the issue. Gulan70's comment is spot-on: this is a MSFT performance issue, and they need to acknowledge it as such and deploy a fix. I'm staring at a query right now that has been validating for 30 minutes, against 9 tables in SQL Server with only 1-2 million rows combined. This kind of performance is absolutely pitiful.