Thanks for using MS Q&A
The limitations you mentioned (80 MB and 5K records for a single query) are generally applicable to the Dataverse connector. However, when it comes to FetchXML queries in a Dataflow, it’s possible that these limitations might not apply in the same way.
As you mentioned, you can use FetchXML to retrieve more than 5K records without additional logic. This is because ADF uses paging to retrieve data from Dataverse, which means that it retrieves data in batches of 5K records. When you use FetchXML, ADF automatically handles the paging for you, so you can retrieve more than 5K records without any additional logic.
It’s important to note that the behavior you’re observing could be due to specific implementation details of the ADF Dataverse connector or the way ADF handles FetchXML queries in Dataflows.
I hope this helps! please do Let us know if you have any further questions.