Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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 wi...
Need Help
xzmiche's avatar
xzmiche
Icon for Resolver I rankResolver I
5 years ago

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