I'm experiencing an issue with Google Analytics data in Power BI. Google Analytics has been added as a data source, and it can refresh data in Desktop mode, and it can manually refresh the dataset when uploaded/published to powerbi.com.
But when I try to set a schedule, it gives the following error:
Obviously I clicked "edit credentials", verified the credentials with succes (OAuth2, I tried different privacy levels), and then tried another manual refresh, which worked. But it is still not possible to set a new scheduled refresh (it's greyed out), and the screen above does not change. The little circle keeps spinning and it still says the credentials are invalid.
Does anyone know what the issue could be?
Same issue. The data reload works fine in Power BI Desktop, but then fails in the service.
I also get an 'Invalid credentials' error under data source credentials in the dataset options, even after updating them and getting a temporary 'succesfully updated' message.
Hey I think I managed to find a workaround. Try using Microsoft Edge instead, then refreshing each credential, for me it was GA/Sharepoint/Web I was then able to edit my refresh schedule. But the second I went back to chrome, it was greyed out and spinning again (but it still refreshes, you just can't adjust it).
If that doesn't work for you, try deleting the credential in desktop data sources first, not sure if that had anything to do with it but I did this before trying edge.
Noting that I encountered the same issue, luckily after removing and re-adding the credentials in desktop I was able to get refreshes working online. The only caveat is it always says credentials are invalid despite still working, GA continues spinning, and all the scheduled refresh options are greyed out.
Any chance someone's had success here?
I've been running Google Analytics connections successfully for 2+ years. But just recently, the same issue as popped up and cannot be fixed with the variety of solutions I've tried.
I'd prefer fixing the GA connection, rather than trying to rebuild all my sources in Google Sheets & rebuilding my PBI reports.
I'm having the same issue since last week.
The GA connection works fine on Power BI Desktop.. But It's not working for schedule refreshing.
Can someone please?
I found workaround.
I used Method 2 on this link https://measureschool.com/google-analytics-to-google-sheets-export/ to download analytitcs to google sheet.
Then I followed this guide https://natechamberlain.com/2019/10/08/connect-a-google-sheet-spreadsheet-to-power-bi-as-a-data-sour... to connect to google sheets.
Scheduled refresh is now working.
Hopefully this workaround works for you.
Same problem here. I tried to edit, remove and re-enter the credentials several times, tried different privacy levels, but nothing works. It seems to accept the credentials, but the alert saying that the refresh schedule cannot be enabled, does no go away. No refresh schedule possible...
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!