Thanks Maja/@mspanic
In my research last night I did come across the Tada page which was great.
Based on what I have seen so far there are two options that I will investigate with my manager, both of which require a company Google Cloud Platform account.
The first is a custom connector created by a data scientist called Gavin who is based in Scotland and had faced the same issue as me: https://cooriedug.com/custom-ga4-power-bi-connector-setup/
The second is using BigQuery - whilst there is an associated cost I believe it would be very low for my organisation, the Real Estate Institute of New Zealand. Early data suggests < 100,000 total users a week. More on that solution here: https://www.optimizesmart.com/how-to-connect-google-analytics-4-with-bigquery/#11-what-is-the-cost-of-using-bigquery-for-ga4- or here: https://support-google-com.translate.goog/analytics/answer/9823238?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp
I hope this helps someone else looking at the same problem and waiting for Microsoft to update their GA Connector
David