Unable to combine data...AutoRemovedColumns1...Please rebuild this data combination

[Anonymous]

Hi, can anyone help to mask these two queries together with function? Refreshed successfully in PBI desktop but error in PBI web service. Already tried ignore privacy settings and anonymous

let

Source = Web.BrowserContents("https://companysales.com:businessReportTemplate?username"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE > * > TR > :nth-child(1)"}, {"Column2", "TABLE > * > TR > :nth-child(2)"}, {"Column3", "TABLE > * > TR > :nth-child(3)"}, {"Column4", "TABLE > * > TR > :nth-child(4)"}}, [RowSelector="TABLE > * > TR"]),
#"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"", type text}, {"File Name", type text}, {"Size (bytes)", Int64.Type}, {"Date Modified", type text}}),
#"Extracted Text Before Delimiter" = Table.TransformColumns(#"Changed Type", {{"Date Modified", each Text.BeforeDelimiter(_, ","), type text}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Extracted Text Before Delimiter",{{"Date Modified", type datetime}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type1", let latest = List.Max(#"Changed Type1"[Date Modified]) in each [Date Modified] = latest)
in
#"Filtered Rows"

let
Source = Excel.Workbook(Web.Contents("https://companysales.com:", [RelativePath="businessReportTemplate?username=JohnDoe&doc="&Latest[File Name]{0}]), null, true)
in
Source

[v-eachen-msft]

Hi @Anonymous ,

Here is the link about Web.Contents(). You could use "Query" to define parameters.

For more details, here is a more specific article for your reference:

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

[lbendlin]

https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

[camargos88]

Hi @Anonymous ,

Ignoring the privacy levels won't work on the service, you need to do it on the same query.