Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have multiple dashboards and all are fetching data from google analytics. However, one of them is refreshing for more than one hour as there are more than 1 million records to pull from GA. But the refresh is failing after 1 hour exactly. I guess this is because of OAuth 2.0 authentication which has an expirty time of 60 minutes for an acess token. I think Power BI is not able to refresh the access token once it is expired. Does any one faced this issue? Any ideas on how to resolve this issue? Below is the screenshot for reference. Also, the error number is 401 which means that access token has expired.
You are correct. Power BI can't refresh the Google Analytics access token once it's expired. Since the Google Analytics connector is based on Google Analytics Core Reporting API, you may consult Google Analytics to solve this issue.
See a similar thread below:
Regards,.