Data limit in powerbi

[Anonymous]

Hello,

I am wondering  can we set data limit in power BI desktop? If that can be done how to do that?

Basically datas are coming from SQL DB and I want to set a limit of 5k or 8k because in sql db more than 50k data are present in  a particular table or view.

Please suggest me! 

[amitchandak · Accepted solution]

@Anonymous , One of the ways is to use the advance option in connection and write a query and put filters.

[m3tr01d · Accepted solution]

@Anonymous The developer of the dataset make his own limit, either in Power Query using a filter or using SQL.

Also 50k is really no problem for Power BI.

[m3tr01d · Accepted solution]

@Anonymous The developer of the dataset make his own limit, either in Power Query using a filter or using SQL.

Also 50k is really no problem for Power BI.

[amitchandak · Accepted solution]

@Anonymous , One of the ways is to use the advance option in connection and write a query and put filters.

[Anonymous · Accepted solution]

Thank you so much @amitchandak. This is helpful..