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 more than 50k data are present in  a particular table or view.

Please suggest me! 

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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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.