Hi ,
I am facing error while scheduling a data refesh job for web connection in PBI report server.
The data refresh task works with out any errors in Power bi desktop however i get following error when i schedule data refresh job.
-1055784932: The import Html.Table matches no exports. Did you miss a module reference?. The exception was raised by the IDbCommand interface.
web connection I am using in Power querry is as follow
let
Source = Web.BrowserContents("https://www.upstreamonline.com/tag/news"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".row:nth-last-child(5):nth-child(1) > .col-12 > DIV.card.teaser.teaser-type-medium.mb-3.border-top.pt-2.flex-grow-1:nth-child(1):nth-last-child(1) > DIV.card-body:nth-child(1):nth-last-child(1) > .teaser-body"}, {"Column2", ".teaser-body-image > A:nth-child(1):nth-last-child(1)", each [Attributes][href]?}}, [RowSelector=".row:nth-last-child(5):nth-child(1) > .col-12 > DIV.card.teaser.teaser-type-medium.mb-3.border-top.pt-2.flex-grow-1:nth-child(1):nth-last-child(1) > DIV.card-body:nth-child(1):nth-last-child(1) > .teaser-body"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}})
in
#"Changed Type"
Any help in resolving this issue or workaround is appricated,
Also let me know if any further details are required.
Regards,
Tushar
