Dynamic Date and element in Power BI URL

Mehay ,

Yes, it's like a macro in Excel.

It keeps all the steps and apply them when the refresh happens.

Hi Mehay ,

We get this error if the page load is slower than the Power Query request, to fix it, use this code:

let
    Source = Web.BrowserContents("https://www.apple.com/covid19/mobility", [WaitFor = [Timeout = #duration(0,0,0,3)]]),
    Extract = Html.Table(
                            Source, 
                            {
                                {"Link", "#download-card > div.download-button-container > a", each [Attributes][href]}
                            },
                             [RowSelector="#download-card > div.download-button-container"]
                        ){0}[Link],
    GetData = Csv.Document(Web.Contents(Extract),[Delimiter=",",Encoding=65001, QuoteStyle=QuoteStyle.None])
in
    GetData

I just added a timer to delay the load of the page in Power Query.