Search code examples
powerbipowerquerym

Transforming a table column using a function

i would like to run the Web.Contents function across a column containing urls (excel file downloads) in my table. I am hoping to transform this url column into a column of Excel workbooks by using Web.Contents and then Excel.Workbook to convert the web contents into an excel workbook. I do not want to add a new/custom column.

The problem is when i try to do this using the code below, i get an expression error. I am not sure what i am doing wrong, i suspect i may be referring to the urls incorrectly within the Web.Contents function.

let
TransformedTable = Table.TransformColumns (Table, {"Urls", each Web.Contents([Urls])})
in
TransformedTable
Solution

  • Try this code:

    = Table.TransformColumns (Table, {"Urls", each Web.Contents(_)})