Sales Anyalytics for D365 template

Hi All,

I have all the relevenat priviledges and permissions set up. I have admin rights to the workspace and the correct credintials. The data connection is fine.  However, once I install the Sales Anyalytics for D365 template app and add my data I get the error...

Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Data refresh failed as query exceeded the maximum limit of 100000 records. Dynamics CRM Online data refresh is limited to maximum of 100000 records per query."}}],"exceptionCulprit":1}}} Table: Activity.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 0d3a245a-9fe0-4751-8619-f0fc3819fb38
Request ID: e92f4405-0ef2-3cc6-59c2-5e13c361dc6f
Time: 2024-12-06 16:57:15Z

There are more than 100,000 rows of data in the CRM.. But I cant find any way to modify the data connection to restrict the extract to <100k rows?

I have followed this guide https://learn.microsoft.com/en-us/dynamics365/sales/configure-sales-template-apps I get to the end of step 3, the app starts the refresh with no errors. then fails due to the 100k limit reached...

Is there an easy way to fix this issue? I have looked all over the internet and cant find any information on how to bypass this 100k limit.. I cant be the only person with more than 100k rows of sales data.. 

any help much appreciated..

thanks

J