There seems to be a connector for GA4 data now, unfortunately, although it works in the Power Query, as soon as you click 'Close & Apply' it fails with an error.
Error:
...
Also tagging along here.
I maintain a client's online commerce dashboards and they import GA data for analysis.
Anonymous we opted for a month-to-month Windsor.ai contract until this works.
Hope it gets sorted out soon. I would have thought Microsoft would have the GA4 implementation working well before UA gets retired.