cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mateusz_Płonka
Frequent Visitor

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

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"
2 REPLIES 2
v-kkf-msft
Community Support
Community Support

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

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors