Data Gateway refresh causing huge CPU spikes on SQL server (Dynamics 365)

I have a couple of Power BI reports which query Dynamics 365 SQL databases via a scheduled Data Gateway refresh. When run these refreshes cause huge CPU spikes on the SQL server which in turn causes ...