The remote server returned an error: (429). (429 TOO MANY REQUESTS)

[Mateusz_Płonka]

Hello, Im facing a error as topis says, and i know that solution is to use delay function wchich I put in my code but i still see this error did i put it in the wrong place or should i put it in every step if so then how?

Btw. Im using dataflow, refresh worked fine for a few days, i am seeing this error since today.

let

    Source = SharePoint.Contents("https://danone-my.sharepoint.com/personal/amparo_cornejo_danone_com/", [ApiVersion = 14]),

    Documents = Source{[Name="Documents"]}[Content],

    #"Weekly Global EU Power BI" = Documents{[Name="Weekly Global EU Power BI"]}[Content],

    #"Clusters Weekly Files" = #"Weekly Global EU Power BI"{[Name="Clusters Weekly Files"]}[Content],

    #"IBERIA Weekly Files" = #"Clusters Weekly Files"{[Name="UGIBN Weekly Files"]}[Content],

    #"Filtered rows" = Table.SelectRows(#"IBERIA Weekly Files", each not Text.Contains([Name], "~$")),

    #"Filtered Hidden Files1" = Table.SelectRows(#"Filtered rows", each [Attributes]?[Hidden]? <> true),

    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each FunctionInvokeAfter(()=>#"Transform File"([Content]),druation(0,0,0,1))),

    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),

    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),

    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Removed Other Columns1", {"Transform File"}),

    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Errors", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),

    #"Renamed Columns" = Table.RenameColumns(#"Expanded Table Column1",{{"Source.Name", "Plant"}}),

    #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Renamed Columns", {{"Plant", each Text.BeforeDelimiter(_, "."), type text}}),

    #"Changed Type" = Table.TransformColumnTypes(#"Extracted Text Before Delimiter",{{"Plant", type text}, {"KPI", type text}, {"Week", type text}, {"Value", type number}}),

    #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Value", null}})

in

    #"Replaced Errors"

[v-kkf-msft]

Hi @Mateusz_Płonka ,

Do you want to limit the number of queries sent to the data source in a certain time? Maybe you can try the Value.WaitFor function.

https://docs.microsoft.com/power-query/helperfunctions#retrieving-data 

Error 429 too many request on Power Query 

Best Regards,
Winniz

[Mateusz_Płonka]

Hello, could you show me how I could implement it in the above code, and then I can handle the rest of the queries?

Unfortunately, my knowledge is not sufficient and I am unable to add the functions correctly