power bi desktop import from Google Analytics

[boomerang]

Hello
Could someone tell me why, when importing google analytics data from a single account, the result shows me all accounts ???

And aslo i can't find Avg Position column

[v-ljerr-msft · Accepted solution]

Hi @boomerang,

If you open advanced editor in Query Editor, you will find that the Google Analytics connector uses GoogleAnalytics.Accounts function(M) which returns all the Google Analytics accounts for the current credential. And the connector in Power BI Desktop rely on the Google Analytics Core Reporting API. As such, features and availability may vary over time. 

Regards

[boomerang]

Thanks a lot! appreciate 🙂

[boomerang]

Hello
could someone tell me why, when importing google analytics data from a single account, the result shows me all accounts ???

also i can't find Avg. Position column