Web Connection : Error while creating data refresh schedule job

Anonymous — Mon, 23 Mar 2020 07:32:54 GMT

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

Re: Web Connection : Error while creating data refresh schedule job

KBO — Wed, 25 Mar 2020 08:35:34 GMT

Hi Anonymous ,

sounds simillar to this issue:

https://community.powerbi.com/t5/Service/Data-refresh-error-The-exception-was-raised-by-the-IDbCommand/td-p/488624

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

topic Re: Web Connection : Error while creating data refresh schedule job in Report Server

Web Connection : Error while creating data refresh schedule job

Re: Web Connection : Error while creating data refresh schedule job