what is Maxium limits Direct query using rows size?

Hi Aruna_ln,

In a DirectQuery mode, your Power BI Report sends SQL query per each visual element (tile) separately.

For instance, you have a table where show two fields: City and SalaryUSD. In the same time, your SQL table with cities data has 20 mln rows. If you drop to visual element (table) City and not aggregated SalaryUSD then Power BI will send a query like below

select City, SalaryUSD
from cities

which will return 20 mln rows and will try to show it via table visual in Power BI, but it has a limit of 1 mln rows to render.

And if you are able to change SQL query and do aggregation like below

select City, sum(SalaryUSD) as SalaryUSD
from cities

and in case result output of this query will have less than 1 mln rows then it will be rendered on the report.

There is a possibility to track which query is sending by Power BI to SQL Server using SQL Server Profiler tool. In case of Azure SQL then you can use only Extended Events.

Hi Aruna_ln,

SQL Profiler tool not able to connect to Azure SQL. So you can use only Extended events in this case, see a link - https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/03/13/extended-events-capture-step-by-step-walkthgrough/ . 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!