cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smpa01
Super User
Super User

datasource.error: sharepoint: request failed: the remote server returned an error: (429)

Hi,

 

I have this follwing query which connects to a Office 365 shareporint folder. I am consuming a web service with SOAP call. Powershell makes the SOAP call and creates a subfolder by each date inside a static folder (office 365 sharepoint location) and saves the xml responses there. Each subfolder contains about 1500 xml files. I connect PQWRY to that sharepoint folder.

 

Following is my PQWRY which I am running on service

 

 

let
  Source = SharePoint.Files("https://xyz.sharepoint.com/teams/CapData", [ApiVersion = 15]),
  #"Removed columns" = Table.RemoveColumns(Source, {"Attributes", "Date created", "Date accessed", "Folder Path"}),
  #"Filtered Rows" = Table.SelectRows(#"Removed columns", each [Extension] = ".xml"),
  #"Removed columns 2" = Table.RemoveColumns(#"Filtered Rows", {"Extension"}),
  #"Filtered Rows1" = Table.SelectRows(#"Removed columns 2", each Text.Contains([Name], "modified-bill")),
  #"Added custom" = Table.AddColumn(#"Filtered Rows1", "Custom", each Xml.Tables([Content])),
  #"Removed columns 1" = Table.RemoveColumns(#"Added custom", {"Content"}),
  #"Inserted date" = Table.AddColumn(#"Removed columns 1", "Date", each DateTime.Date([Date modified]), type date),
  #"Filtered rows 1" = Table.SelectRows(#"Inserted date", let latest = List.Max(#"Inserted date"[Date]) in each [Date] = latest),
  #"Expanded Custom" = Table.ExpandTableColumn(#"Filtered rows 1", "Custom", {"Table"}, {"Table"}),
  #"Expanded Table" = Table.ExpandTableColumn(#"Expanded Custom", "Table", {"Table"}, {"Table.1"}),
  #"Expanded Table.1" = Table.ExpandTableColumn(#"Expanded Table", "Table.1", {"Table"}, {"Table"}),
  #"Expanded Table 1" = Table.ExpandTableColumn(#"Expanded Table.1", "Table", {"Table"}, {"Table.1"}),
  #"Filtered rows" = Table.SelectRows(#"Expanded Table 1", each [Table.1] <> null),
  #"Expanded Table.1 1" = Table.ExpandTableColumn(#"Filtered rows", "Table.1", {"Table"}, {"Table"}),
  #"Removed columns 3" = Table.RemoveColumns(#"Expanded Table.1 1", {"Date"}),
  #"Expanded Table 2" = Table.ExpandTableColumn(#"Removed columns 3", "Table", {"a", "b", "c", ----"z"})
in
  #"Expanded Table 2"

 

 

 

and it returns the follwoing error

 

 

 

datasource.error: sharepoint: request failed: the remote server returned an error: (429). (429 too many requests)

 

 

 

Does anyone know how to prevent this ?

 

Thank you in advance.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


1 ACCEPTED SOLUTION
smpa01
Super User
Super User

Thanks @Fowmy. The delay is added by

//adding 1second delay

X=Function.InvokeAfter(()=>SharePoint.Files(),#duration(0,0,0,1))





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


View solution in original post

3 REPLIES 3
smpa01
Super User
Super User

Thanks @Fowmy. The delay is added by

//adding 1second delay

X=Function.InvokeAfter(()=>SharePoint.Files(),#duration(0,0,0,1))





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


View solution in original post

Hi,

Where do you add this delay ? 

Fowmy
Super User
Super User

@smpa01 

Can you check this link? 

 

Add a delay 

 

https://community.powerbi.com/t5/Developer/Error-429-too-many-requests/td-p/62383

 

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


WebsiteYouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors