Forum Discussion
Google analytics will not refresh
Hi. When you are working with cloud and onpremise data you need to specify your gateway that there is data that can be cloud with a check box in its configuration. Once you do that you can configure the credentials for cloud and only add sources for gateway. Go to gateway settings and activate:
The configure its credentials like the report with only analytics. That should be enough for it to refresh. You usually don't have to add a source in the gateway for cloud data.
You can read about this additional gateway settings here: https://blog.ladataweb.com.ar/post/647097339965734912/powerbigateway-opciones-de-interés-en-puerta-de
I hope that helps,
Unfortunately, that option is already checked.
I should have added, to my original question, the following:-
the report in question, initially existed under a different name, and as far as I can remember, the data, including Google analytics, was refreshing. A few weeks ago, I created another copy of the report, in order to adhere to our naming standards. It was only yesterday, I realised I had never set up the scheduled refresh, for this copy of the report.
Also, I have a different report, using a different workspace, that successfully refreshes its data, including Google analytics.
Any further suggestions?
Thanks
- v-xiaotang5 years agoCommunity Support
Hi Dragon496
do you mean you have a reportA uses both databases, through a gateway and Google analytics, and the report refreshes OK.
then you create a copy of reportB, and its refresh on service through gateway fails while refresh in desktop works OK, right?
Besides, you have a different report using different datasource & workspace, successfully refreshes its data?Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- Dragon4965 years agoHelper II
They are different reports, using different database tables and Google analytics! Although, after fixing this one, I need to make changes to the report that is working (and hopefully not break it!). The changes, however, do not involve Google analytics.
We have looked at the privacy levels and believe they are okay.
I have a new report, for testing purposes. Added Google analytics, published it and it successfully refreshes. I have added one database table and it still refreshes-that's as far as I got yesterday. My first task today is to add a relationship between the database table and the Google analytics table. They question really is how far I go, as I really do not want to end up replicating the report (long story but we are trying to limit the amount of Power BI report, since it is not the best with my voice recognition software).