Forum Discussion

Mehay's avatar
Mehay
Helper I
6 years ago
Solved

Dynamic Date and element in Power BI URL

Hi everyone,    Plz help me on this.   1. I'm trying to format my URL in the way that it takes 2-3 days prior data I found out that this code (below) will work for today, but how do I change it ...
Need Help
Show and Tell
  • camargos88's avatar
    camargos88
    6 years ago

    Mehay ,

     

    Yes, it's like a macro in Excel.

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

  • camargos88's avatar
    camargos88
    6 years ago

    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.

Mehay's avatar
Mehay
Helper I
6 years ago

the 2nd approach basically works well, it got exactly what I need.

 

Just a quick question, will my all filters remain same even after new data uploads in the apple system?

camargos88's avatar
camargos88
Community Champion
6 years ago

Mehay ,

 

Yes, it's like a macro in Excel.

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

  • Mehay's avatar
    Mehay
    Helper I
    6 years ago

    camargos88 ,

     

    Perfect, really appreciate your help, and thanks for all effort! 

    It worked perfectly, so now i just need to put a time slot for its own refresh once  a day.

     

    Regards, 

    Mehdi

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    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.

  • Mehay's avatar
    Mehay
    Helper I
    6 years ago

    Dear camargos88 ,

     

    Now every time i try to refresh data it gives me error liek this with href file. Sometimes i open codes and just click okay and then data seems to be fine again, not sure what causes the problem.

     

     

     

  • Mehay's avatar
    Mehay
    Helper I
    6 years ago

    camargos88 ,

     

    Once again thanks for your help, seems like working for now, hopefully its only error.

    Have a great day ahead!

     

    Regards, 

    Mehdi