Different results with same query using Google Analytics Built-In Connector

Hi v-qiuyu-msft

I implemented a workaround.

I got manually the Access Token and the Refresh Token using Google OAuth 2.0 Playground. I saved them in Power BI as parameters.

Then I created a function that returns the Access Token using the Refresh Token. In this way, I don't need to retrieve the Auth Code and the Access Token.

When the query is updated, the Access Token is refreshed by the refresh function using the Refresh Token.

Now, I hope that:

• when the Access Token reachs zero as expire time, it will be able to be refreshed using the Refresh Token.
• the Refresh Token never expires.

If both these points are true, I can retrieve always data from Google Analytics using a single Refresh Token.

What do you think? Could it work always?

Regards

Lino