Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Advocate I
Advocate I

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.


    Source = SharePoint.Contents("", [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}})
    #"Replaced Errors"
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. 

Error 429 too many request on Power Query 


Best Regards,

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.