Data refresh of Google Analytics data in PowerBI online

[kendash]

We are using data from Google Analytics in PowerBI. We prepare dashboards in PowerBI desktop and publish them into online interface. However, when we try to refresh some of our data sets, we get an error "The credentials provided for the GoogleAnalytics source are invalid. (Source at GoogleAnalytics.)"

The thing is that those are the same credentials as we used for getting data in PowerBI desktop and they worked fine. However, in online interface, we get this error. Moreover, for other datasets, which we published online and which are built on Google Analytics data, with the same credentials, data refresh works fine.

We have two hypothesis, why it might not work:

1. Some datasets does not work, when we used merging queries feature in PowerBI desktop for the creation of dashboards (we merged two queries). However, when we tested it with another dataset, it worked.

2. Some datasets does not work, when we used calculated columns feature in PowerBI desktop (merging columns using formulas). However, when we tested it with another dataset, it worked.

Do you any suggestions, what is the reason?

[danielarias]

Hello friends, do I have the same problem, any solution that you have applied?

[andershh]

I know I am a little late "to the party" so to speak. But I have been having this problem for the last two weeks. I have attempted the Google Incognito solution and while it solved the problem at first - the issue returned the day after.

Has anyone been able to solve this problem long-term? Any help or tips would be greatly appreciated.

Thanks!

[pavelveret]

I have the same issue

[Anonymous]

I just saw someone createdc an issue of this, we need more votes!

https://ideas.powerbi.com/forums/360879-issues/suggestions/15031830-cannot-refresh-google-analytics-...

[Anonymous]

Hey guys, this started working for me a couple of days ago. Anyone still having issues or is it fixed for everyone?

[binitjoshi]

Clearing my browser's cache solved this issue for me

EDIT - This did not work after few refreshes.

[chrisedwards]

This still hasn't been resolved. Can anyone from the product team please step in here and provide an update?

[Anonymous]

Hi Everyone!

I´m having the same problem.

Any Clue about this?

[Anonymous]

Would be nice to get an update about this, I'm still eagerly awaiting the moment when Google Analytics refresh works in powerBI service!

[aldodfm]

It stills happens....

[NickBI]

I raised a ticket and was told to try the refresh in incognito browser - seems to have worked (only one refresh so far though)

Message from support

"please try the following:

-sign in incognito or an in-private browser window during connection and try the refresh.

- clear the browser cache and try the  to refresh."

What I did

Closed PowerBI desktop

Open incognito browser (chrome)

Login to PowerBI.microsoft.com

Settings - datasets - data source credentials

Updated the Google analytics credentials with username and password - authorize for offline access etc.

seems to be working so far for scheduled refreshes.  I guess that it was associated with a couple of google accounts cached in my browser.

EDIT - Nope, next two scheduled refreshes failed. 

"The credentials provided for the GoogleAnalytics source are invalid."

[netwire]

I have the same problem and tried signing in via incognito. The "Refresh Now" works some times but doesn't other times. the Scheduled Refresh also works some days and not other days.

[Anonymous]

Same here, refreshes seem to work sometimes, fail others. It's a bit random. Glad to hear they are aware of the issue.

[chrisedwards]

My ticket was raised to product team. They are aware of the problem and fix is underway- no ETA on deployment of the fix.

[dima]

Hello!

I have the same problem with data refreshing of Google Analytics data in PowerBI online.

Please, resolve this problem

[googlogmob]

We are using data from Google Analytics in PowerBI. We prepare dashboards in PowerBI desktop and publish them into online interface. However, when we try to refresh some of our data sets, we get an error "The credentials provided for the GoogleAnalytics source are invalid. (Source at GoogleAnalytics.)"
The thing is that those are the same credentials as we used for getting data in PowerBI desktop and they worked fine. However, in online interface, we get this error. Moreover, for other datasets, which we published online and which are built on Google Analytics data, with the same credentials, data refresh works fine.

[chrisedwards]

I encourage anyone experiencing this to open a ticket with Power BI. I have but haven't heard anything back yet. If you have Office 365 and are on the old support model you can open a ticket directly to the Power BI team in your 365 admin panel. If you are on Office 365 and your support is through the concierge you need to open the ticket with the concierge and have them escalate the ticket to the Power BI team.

If you aren't on 365 there is a free level of support offered (maximum 10 hours). You can open a ticket here: https://powerbi.microsoft.com/en-us/support/ (Click contact support at the bottom).

Would love to see this addressed. The GA data source is the only one I'm having trouble with now.

[ES]

The way that I understand this is that when you are connecting only to Google Analytics data the service connects directly to google.  However, when you merge another dataset it uses your personal gateway to make the connection as it creates the entire data model on the fly. 

I have seen instances where the personal gateway "gets confused" (technical term) by swapping google accounts within the same browser.  For example, if you're logging in with a personal/test account on the same browser as your corporate account.  I know this does not make sense as the service is independant of the browser, but I have seen this resolved by clearing the user's cache and having them only use 1 google account on the browser in which they interact with Power BI. 

Hope that helps.  Would love to see a response from Microsoft on how this actually works behind the scenes.  Another option might be having your IT department take a look at the last section of the article below. 

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshooting-power-bi-personal-ga...

-E

[aldodfm]

Hello,

The same here, but is random:

And i can say that the credentials are ok. Someone from PowerBi Team can answer?

[peliason]

I'm having the same issue, too. GA sign-on work perfectly fine when I refresh using the designer tool, but doe not refresh properly through personal gateway.  Please resolve!!!