locked
Dynamic Cell Reference (URL) for Power Query RRS feed

  • Question

  • Hello,

    I am building a project that references a URL. The URL is in a specific cell (for example, B1) and the URL changes based on inputs within the workbook.

    I have a power query that loads a table. By going into the Advanced Editor, I can change the URL while keeping the formatting (deleting columns, for example). The following is the code within advanced editor (I am omitting the formatting since that is not at issue here)

    let
        Source = Web.Page(Web.Contents("specificURL")),
        Data0 = Source{0}[Data],

    What I am struggling with: I need "specificURL" to reference a cell within the workbook, and change when I change the inputs (I can refresh the connections to load the new data from the new URL). Is there a relatively simple solution to this?

    I appreciate any help.

    Thank you,

    LVSB

        
    Thursday, October 22, 2020 9:14 PM

Answers