Understand that Power BI Direct Query have limitation of one-million-row. How can I check in Power BI current visuals in dashboard have loaded how many rows data via direct query?
For example dataset A in datawarehouse for 4 months data we have 76 million rows, however Power BI dashboard only show 1 month data and have applied few filters as dashboard default view. We tried to query from datawarehouse with same filter applied in dashboard which obtain 700k rows.
Can we conclude that dashboard default view with filtered also query 700k rows of data in Power BI direct query mode? If not kindly advise how should I check number of rows loaded using direct query method.
Thanks in advance.
There is such a sentence in the document:
The error that would be returned would be: "The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows."
So the number of rows is abstract in DQ, and there is no need to entangle specific figure.
Tools that can be analyzed can only view the duration time: performance analyzer and SQL Server Profiler tool.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I just saw this study posted by Chris Webb on Linked in and thsi might help explain why you see 700K.
Relevan portion From his blog :
The reason is that, at the time of writing at least, the Analysis Services engine can only push a top(n) operation down to a DirectQuery SQL query in very simple scenarios where there are no measures and no aggregation involved – and in this case we’re summing up values. As a result, if you’re using DirectQuery mode and have a visual like this that can potentially display a large number of rows and includes a measure or aggregated values, you may end up with slow performance.
the row count is under the admin-set limit.
As an admin, you can find these new settings on the Admin portal> Capacity settings page , expand the “Workload” on the management tab of the capacity.
Thanks for the reply.
However my Power BI account is Pro account, capacity settings is only available for Premium account.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!