1000? i see everywhere mostly with 10 as default. 1000 is alot
1000 is fine. Setting a low one means many more hits on the database and can take so much longer. I suspect that this could be your main problem.
why would it take 12 secs for PowerBI to run in the same UAT env and same settings of 10 runs for 12sec in Prod
as already mentioned, ask the DB guys to monitor whats going on within those 13min.
there is enough time to read the DB-execution-plan, which has to be different in these environments
Is it a simple table you are selecting from or is there a view behind the table?
(even 13 seconds is too long to return 150K records)
Check the settings of the universe and the WebI-report.
Maybe different/wrong cardinality or some cartesian product in join,
or different settings in WebI with âQuery Strippingâ or âDuplicate Recordsâ.