Hi guys,
In PowerBi you can simply add Google Analytics data via the API (Online Services).
Unfortunately the columns that you can select for one data set is limited (DataSource.Error: Requested 8 dimensions; only 7 are allowed.). As you can see I need 8 items from Google Analytics but it's limited to 8... so I created an second data set.
Since I have two data sets I would like to create an relationship between them, so I need an unique value/id where I can create the relation with. Does anybody know where I can find an unique value/id in Google Analytics?
Second question 🙂
In our organization we have several webpages for all the different shop locations that we have, so for example an webadress for our shop in:
- London (www.london.com)
- Amsterdam (www.amsterdam.com)
- Brussels (etc.)
- Berlin (etc.)
I created an report for all those locations so that they can see their own results.
But I also want to have an main report (for our main office) where all the data of those reports is collected an where I can select (with an slicer) which office I want to see.
Hopefully someone can help me with this.
Many thanks in advance!
