Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,.