Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
@Anonymous , One of the ways is to use the advance option in connection and write a query and put filters.
@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 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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |