Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data limit in powerbi

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

     

  • m3tr01d's avatar
    m3tr01d
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you so much amitchandak. This is helpful..

m3tr01d's avatar
m3tr01d
Icon for Continued Contributor rankContinued Contributor
5 years ago

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.