Forum Discussion
Advocate IData refresh of Google Analytics data in PowerBI online
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?
26 Replies
googlogmobAdvocate II
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.Hello friends, do I have the same problem, any solution that you have applied?
Same issue here.
Any suggestions or idea?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.
Hello!
I have the same problem with data refreshing of Google Analytics data in PowerBI online.
Please, resolve this problem
It stills happens....
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."
My ticket was raised to product team. They are aware of the problem and fix is underway- no ETA on deployment of the fix.
andershhI 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!
I have the same issue
I'm having the same issue, last scheduled refresh was done on last Saturday.
Did you ever find a solution to this issue? I'm having the same problem and haven't got much further with debugging. For what it's worth, i'm also using merged queries and calculated columns in the datasets that fail to refresh.
I'm also having this issue and would like to hear of any solution. I am assuming that it relates to the data modeling work done in Power BI Desktop, because a sample Google Analytics dashboard (pure defaults) refreshes without an error.
Louis
I have the same issue here
I'm experiencing the same problem here. Has anyone opened a ticket on this? I subscribe to PowerBI Pro but the method for opening a ticket described here doesn't exist anymore?
