Forum Discussion
Dataflow - Validating Queries FOREVER + Gateway issues
I been a big evangalist for usage of Dataflow within my 60K something organization. Now all I hear is complains on how slow and unreliable it has become. And I personally experience it too. (PS: ...
I went through the same path: advocated dataflows as the best solution but the reality is sad.
Validating queries takes ages even for querying a single file on a SharePoint. Why is that?
There is a best Solution? Where? Working on Dataflow day by day is turning out to be a bad exprience.
I found that DirectQuery with Dataflow is 10 times slower than doing a DirectQuery from my 6 years old SQL Server, via a Enterprise Gateway.
Can you imagine? Power BI Service to Power BI Service read takes more time than reading from an Power BI Service to OnPremise DB! 😄