pbi desktop query limit rows changes？

Question

when i use pbi desktop direct query to connect my datasource with my connector,it works perfect，when i create a chart with different fields, i found the query limit is not a fixed value，if i use only one demession filed in chart, the sql limit is 501 rows, if i use only one messure filed, the sql has not limit rows, if i use both demession and messure, the sql limit 1000001 rows, pbi desktop is the latest version and i do not set any config about limit. Is this normal??? if yes , how it works? any documents about the sql limit? i find many documents but does not work.... Please help~~~

anonymous · Answer

Hi jinghua,&nbsp;This is normal in Power BI. It supports upto 1 GB of data per visual. you can't see visual to be loaded if you have more than 1 GB of data.&nbsp;You can filter data by removing unwanted Calculated columns, attributes, measures and apply more filter on the visual.&nbsp;The best approach to have SSAS for your data model and calculations to be created. Power BI in-memory will supports upto 1GB whereas, SSAS can supports for huge volume of data. only the results will be shown in Power BI.&nbsp;Regards,Pradeep

jinghua · Answer

so why some query limit 501, some query limit 1000001, i do not set any limit config at pbi

anonymous · Answer

This all get filtered out when you have mapping with other objects.&nbsp;&nbsp;

jinghua · Answer

thank you for you help, could you explain more detail? i am still confused~~~ can i set the query limit in pbi ? I want to know the where to set default query limt ~ as you know ,the database&nbsp; will query with sql limit by datasource&nbsp;

anonymous · Answer

Dear,&nbsp;We can't set query limit in PBI. Its all about the filters that you have applied in SQL query, PBI filters and relationship between objects.&nbsp;&nbsp;Consider table1 has 10 records and table2 has 5 records and when you do a mapping between these 2 tables, then your result set should display only 5 records. Because, PBI does works only for Inner Join of both the objects.&nbsp;You can do other joins in an another way. But, relationship would do an inner join in PBI.&nbsp;Regards,Pradeep

Forum Discussion

pbi desktop query limit rows changes？

9 Replies

Related content

desktop Power Query

Change Desktop Darkmode

Power Query Formula.Firewall Error in Desktop

Change to the way Power Query reads Excel files?

Cannot 'OK' Option changes in desktop