Sébastien De Bosscher on 04 Jan 2022 13:03:39
There is a 1000 records limit on the power automate visual in power BI reports. This is a real deal breaker for many use cases. One generic use case is to create a CSV of all records.
Please increase the limit to more than 1'000'000 so most use cases can be covered. _____________________________________
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/increase-power-BI-power-automate-visual-limit/idi-p/1404117#M27489
- Comments (7)
RE: increase power automate visual limit
For BI services dealing with big data, the 1K row limit is too small, even for Pro licenses.Please extend the row limit to 1M rows.
RE: increase power automate visual limit
ビッグデータを扱う BI サービスでは、Pro ライセンスであっても 1K 行の制限は少なすぎます。行数制限を1M行に拡張してください。
RE: increase power automate visual limit
Please increase the limit, 1K records is really too little
RE: increase power automate visual limit
While the use of "Run a query against a dataset" helps expand the row limit, I find I am still limited by the 1000 row limit of the button. I need the values from the button to use as dynamic filters in the query, and if there are over 1000 values, I end up not filtering the dataset totally.
RE: increase power automate visual limit
Spent ages trying to create a Power Automate solution to export a file within my corporate environment to allow select users to access, only to find that when I did get it working, that the row limit is 1000 rows. Why was this deemed acceptable?
RE: increase power automate visual limit
I will be using this visual for so many use cases if the limit was increased. 1000 records is too small of a limit
RE: increase power automate visual limit
Also, may the visual work on published (public) enviroment. It only works on pbi service.