i know this post is not related to D365, but i am facing this error after deploying my report to power bi service, knowing that i am not facing it on power bi desktop
"The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows'".
the error is coming from the sum amount function , once removed the reports works fine.
kindly assist with this urgent request.