how to use a formula as a source for power Query then save that table and append it to the previous

[Anonymous]

Hi Everyone,

I need help with this. So I need 2 things:

1. to search in a list of links on a website for the link with today's date and pull that into Power BI as a source.
 Ex: Today's file will be read as follows = 

                                                        weblink + "PUB_Adequecy2_"+Today date (YYYYMMDD) +".xml"

 so how do you make the Source = Xml.Tables(Web.Contents(weblink + "PUB_Adequecy2_"+Today date (YYYYMMDD) +".xml")

2. Then, the pulled table needs to append to the previous day's table. To build the dataset and have history to compare against moving forward. My thoughts are to make that top part a function that power query loops through and append to the previous day. Still not sure how to do that though

Thank you all for your help.

[Anonymous]

Actually, "+" is not Concatenate in M. Replace the "+" with "&", which concatenates text.

--Nate

[xzmiche]

Try this:

let
SourceToday = Xml.Tables(Web.Contents(weblink + "PUB_Adequecy2_"+DateTime.ToText(DateTime.LocalNow(),"yyyyMMdd") +".xml"),
SourceYesday = Xml.Tables(Web.Contents(weblink + "PUB_Adequecy2_"+DateTime.ToText(Date.AddDays(DateTime.LocalNow(),-1),"yyyyMMdd") +".xml"),
Combined=Table.Combine({SourceYesday,SourceToday})
in
Combined