Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Web Connection : Error while creating data refresh schedule job

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

1 REPLY 1
KBO
MVP

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!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors