Anonymous's avatar
Anonymous
Not applicable
4 years ago
Status:
Done

IDataReader Auto Refresh Error

Hi, I have a couple reports that are pulling data from Google Analytics. All of them are having the same refresh error online but I can refresh them without any issues in desktop. I made sure that I ...
Reports
7700-2's avatar
7700-2
Frequent Visitor
4 years ago

Hey everyone. I believe this is a reoccurrence of the Microsoft quota limits on the Google Analytics API. When pulling data through a dataflow, this error was observed:

Expression.Error: O campo 'errors' do registro não foi encontrado.
Detalhes
code = 429
message = Quota exceeded for quota metric 'Requests' and limit 'Requests per day' of service 'analyticsreporting.googleapis.com' for consumer 'project_number:664933364861'.
status = RESOURCE_EXHAUSTED
details = {[...]}

 

It's been raised several times before, dating as far back as 2019, it shows up and resolves after a few days:

 

Google Analytics API Error - Microsoft Power BI Community

Google Analytics issue: Request failed (403): Quot... - Microsoft Power BI Community

powerbi - Issues with connecting Google Analytics to Power BI - Stack Overflow

 

It will happen as long as Microsoft shares the same API key among all users. What we need is the custom connector to evolve to a point where we can use our own API keys and also select a date range to reduce the amount of data being pulled into our datasets.

 

v-chuncz-msft can you please relay this to the devs?

Completed Ideas