power query with HTML.table not working in SSIS package, but surprisingly works fine in PBI desktop

Hi ryatatu 

From this link I found that HTML.Table function is currently not supported in SSIS.

------------------------------------------------------

The Html.Table nor the Web.BrowserContents functions are currently supported in SSIS. That's because those functions were still in preview when the latest version of the SSIS component was released. The SSIS team hasn't made any updates to the component and it's been the same since 12/24/2019. You could try and use the Web.Page function to emulate a similar approach to the one that you use with the other functions, but if you're solely relying on CSS selectors this might not work.

------------------------------------------------------

Additionally, this blog may be helpful. It is using Web.Page with SSIS. 

Power Query Source for SQL Server Integration Services (mssqltips.com)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Thank YOU!

I made replacement Html.Table was replaced by Web.Page and got success ! 

Now it works! 

let linked_tbls =
(wb as text) as table =>
let
Source = Web.Page(wb),
Data = Source{0}[Data]
in
Data,

Source = Sql.Database("msk-ssbi-001", "DocStat"),
dbo_ORD_PROCESS = Source{[Schema="dbo",Item="ORD_PROCESS"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(dbo_ORD_PROCESS,{"PK", "RelationsLinks"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [RelationsLinks] <> null and [RelationsLinks] <> ""),
#"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each linked_tbls([RelationsLinks])),
#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Тип", "№ проекта", "Рег.номер", "Наименование", "Статус", "Состояние", "Связь"}, {"Тип", "№ проекта", "Рег.номер", "Наименование", "Статус", "Состояние", "Связь"}),
#"Filtered Rows1" = Table.SelectRows(#"Expanded Custom", each [Рег.номер] <> null and [Рег.номер] <> "")
in
#"Filtered Rows1"