GoogleAnalytics.Accounts
Your Google Analytics 4 properties, each with the dimensions and metrics it offers.
Group: Online services. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
GoogleAnalytics.Accounts(optional options as nullable record) as table| Parameter | Type | Description |
|---|---|---|
options | nullable record optional | Accepted as Power Query writes it; none is read. |
Returns
table. Name, Id (properties/<number>), Account and Data, a row per property your sign-in can read.
Remarks
- A property's Data lists what a report can ask for: Kind ("Dimension" or "Metric"), Name (as the API names it), Label and Description.
- Sign in with your own Google Cloud project's OAuth client, or a service account's key.
Compared with Power Query
Power BI goes from an account to a property to the dimensions and measures you tick; OpenBI lists the properties in one table, and GoogleAnalytics.Report reads a report.
Examples
A property's dimensions and metrics
GoogleAnalytics.Accounts(){[Name = "Web shop"]}[Data]Result: not shown here: it needs a Google Analytics account and a sign-in.