Forum Discussion
murthysydney
4 years agoFrequent Visitor
Extracting Table for web -Between date Ranges - Error
Hi All, I am extracting data from web URL in power bi, when the URL is Web.Page(Web.Contents("https://cmmm.internalapps./Default.aspx?Group=3&Status=1&DateFrom=01/01/2000&DateTo=04/05/2022&IsActive...
murthysydney
4 years agoFrequent Visitor
Thanks, Ibendlin
Is it possible to use if statement in the source:
if the below URL finds an ID that contains 100 then get data from the table if not move to the next date, can it be checked date in the loop function?
If You are able to assist with an example will be great.
Let
Source = Web.Page(Web.Contents("https://cmweb.internalapps.?Group=" & Divisonlinkpara & "&Status=0&DateFrom=08/12/2000&DateTo=08/12/2022", [Timeout=#duration(0, 16, 40, 0)])),
lbendlin
Super User
4 years agoI don't have access to your web server. I cannot help any further.