Google Analytics connector in Power Query
The Google Analytics Connector is available in Power BI Designer. Please copy it to Power Query as well.
Adding this to PowerQuery for Excel would greatly reduce the complications now faced when accessing GA from PowerQuery. There's a ten step process that involves registering the app with Google API, getting a key, turning that key into a token, and writing a lot of M. Having a connector would be amazing.
Jesper Ellegaard commented
I believe that the standard GA to PBI connector will only pull aggregates and will also be exposed to sampling.
May I suggest using https://scitylana.com instead? Scitylana will pull all raw data, user by user, click by click unsampled from GA (free edition) into Power BI (and others). This expands the possibilities of web analytics dramatically and enables integration with your own backend data.
Cathy Monier - MVP Excel commented
Power Query in Excel, because The Power BI Designer have already