aggregate data from multiple Google Analytics accounts - ideas?

[Jake_Roesler]

Any ideas on how I might aggregate data from multiple Google Analytics accounts. 

I need metrics on each site - got that. 

But, because each site has a similar purpose, different audience: I'd like to get a consolidated view.

I'd like to do this without having to add two tracking codes to each site. 

Thanks in advance for any feedback!

[MMJen]

Hi, We're also trying to do this with approx 100 properties into one report/dashboard.  Any advice?

[v-sihou-msft]

@Jake_Roesler

If you need to connect Google Analytics with another account in Power BI Desktop, you need to delete the existing cached data source. Then you can apply new credential when connecting  Google Analytics.

Regards,