Store different credentials for Google Analytics

[Garlan]

Hi everyone,

I have two different pbix files that work fine with each a different connection to Google Analytics through the built-in connector. But once I upload both to the service then the credentials get merged and only the last one uploaded is kept which makes it impossible to refresh both.

If I download both pbix from the service I see that they both connect to a single Google email address. This is why the error message is the following, the report in error can connect but with the wrong email address and can't find the tables needed.

Is there a way to separate the credentials or to parameterize them with the built-in connector ?

[floressdiego]

Hello, 

Is this problem still a thing? I am having the same trouble, I have 2 different GA credentials and one forbids the other one from refreshing.

[v-lili6-msft]

hi, @Garlan 

You could refer to this similar post:

https://community.powerbi.com/t5/Service/Can-I-add-two-google-analytics-to-power-bi/td-p/18797

Best Regards,

Lin

[Garlan]

Hi Lin,

Thank you for your answer. Sadly I saw that post and I think it refers to multiple website for a single email address.

In my case I have a report that uses address1@gmail.com to get GA data for one website. If I upload it to the service it works fine.

Then I created another report that uses address2@gmail.com to get GA data for another website. If I upload it to the service it works fine but then the first report doesn't work anymore as it uses address2@gmail.com as well and cannot find the first website.

If I go to the credentials for dataset of the first report I can change to address1@gmail.com for it to work but then the second report won't work anymore as it will use address1@gmail.com as well.

I guess a solution would be to create a custom datasource with M query but I'd like to avoid that since both report work fine on their own.

Best wishes,

Hugo