Forum Discussion

NeilHI's avatar
NeilHI
Regular Visitor
3 years ago
Solved

Add the Source from a Web Page to the Table Created

Hello,   I've spent most of today searching this topic which gets me nowhere.     I have selected "Get data", "Web", and added a URL that allows me to select two tables that I want to extract.  T...
Need Help
RobertPaegelow's avatar
RobertPaegelow
Icon for Helper I rankHelper I
3 years ago

 

To add the URL as a column in your tables in Power BI, you can use the "Add Column" tab in the Power Query editor. This tab allows you to create new columns in your tables by applying formulas or transformations to the existing data.

To add the URL as a column in your tables, you can follow these steps:

  1. In Power BI, open the dataset that contains the tables you want to modify.

  2. In the Power Query editor, select the first table that you want to add the URL column to.

  3. In the "Add Column" tab, click the "Custom Column" button. This will open the "Custom Column" dialog box.

  4. In the "Custom Column" dialog box, enter a name for the new column in the "Name" field. For example, you could use the name "URL" for the column.

  5. In the "Custom Column Formula" field, enter the formula that you want to use to populate the new column with the URL. This formula can use the built-in "Source" function to reference the URL that was used to import the data. For example, you could use the following formula to populate the new column with the URL:

    URL = Source

     

    6. Click "OK" to create the new column.

    After you have added the URL column to the first table, you can repeat these steps to add the same column to the second table. Once you have added the URL column to both tables, you can use it to link the tables together and append the data in your report.

  • NeilHI's avatar
    NeilHI
    Regular Visitor
    3 years ago

    I thought it was that easy but it was not.

     

    My steps with the first table in Power Query Editor were:

    • Select Add Column tab,
    • Selecdt Custom Column,
    • Typed "URL" in New column name,
    • Typed "Source" (without the quotes) in Custom column formula,
      • Formula looked like: = Table.AddColumn(#"Changed Type1", "URL", each Source)
    • Selected OK.

    That results in the entire HTML string being placed in the field and not the URL path, which is what I'm looking for.