flavia's avatar
flavia
Advocate II
3 years ago
Status:
Accepted

(429): Too Many Requests

Hi everyone!

 

I'm facing this issue below during updates of my report in Power BI Service.

 

The report is connected to a sheet of google, and it's updating 8 times in a day.

 

 

"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>Falha no Web.Contents ao obter conteúdo de 'https://sheets.googleapis.com/v4/spreadsheets/1xCgtP85XBEo6LyRSI_RUjCrp73KENpg19DUcfNKuNi8?ranges=AGOSTO%202023!A1:AD994&fields=sheets/data/rowData/values/effectiveFormat/numberFormat,sheets/data/rowData/values/effectiveValue' (429): Too Many Requests</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"GoogleSheets"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://docs.google.com/spreadsheets/d/1xCgtP85XBEo6LyRSI_RUjCrp73KENpg19DUcfNKuNi8/edit#gid=61024033"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://sheets.googleapis.com/v4/spreadsheets/1xCgtP85XBEo6LyRSI_RUjCrp73KENpg19DUcfNKuNi8?ranges=AGOSTO%202023!A1:AD994&fields=sheets/data/rowData/values/effectiveFormat/numberFormat,sheets/data/rowData/values/effectiveValue"}}],"exceptionCulprit":1}}} Table: fProjeções.

 

Some phases are in portuguese.

 

How can I solve this? 😉

5 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  flavia ,

     

    We have seen on the internal platform that other engineers have reported this issue and submitted it.
    The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

     

    Best regards.
    Community Support Team_Caitlyn

  • Hi!

    I have an update schedule at 10am in power bi service

     

    This issue is always occurring at this time.

  • Anonymous's avatar
    Anonymous
    Not applicable

    update:

     

    This issue is still in investigating.

     

    Best regards.
    Community Support Team_Caitlyn

  • Hi

     

    How can I solve this issue? it is still happening.

  • Anonymous's avatar
    Anonymous
    Not applicable

    update:

     

    This issue is still in investigating. no workaround for now.

     

    Best Regards,
    Community Support Team _ Caitlyn