Please make sure your data gateway (personal mode) is installed and configured properly

[odumna]

Hi
I have a problem with refreshing my report on portal.
I get error "Please make sure your data gateway (personal mode) is installed and configured properly."

In Report I use only one datasource. This datasourse is the web site "https://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-12-months.....

In Desktop the report refresh successfully. But on portal I get error "Please make sure your data gateway (personal mode) is installed and configured properly."

What do I need to do ? What and Where do I need check to resolve the issue?

Exmple of my query 

let
Source = Web.BrowserContents("https://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-12-months...."),
#"Table from HTML" = Html.Table(Source, {{"Column1", "TABLE:nth-child(15) > TBODY > TR:nth-child(1) > TD:nth-child(1) > TABLE:nth-child(1) > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE:nth-child(15) > TBODY > TR:nth-child(1) > TD:nth-child(1) > TABLE:nth-child(1) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(2)"}, {"Column2", "TABLE:nth-child(15) > TBODY > TR:nth-child(1) > TD:nth-child(1) > TABLE:nth-child(1) > * > TR > TD[colspan=""2""]:not([rowspan]):nth-child(1):nth-last-child(1), TABLE:nth-child(15) > TBODY > TR:nth-child(1) > TD:nth-child(1) > TABLE:nth-child(1) > * > TR > TD:not([colspan]):not([rowspan]):nth-child(1):nth-last-child(2) + TD:not([colspan]):not([rowspan]):nth-child(2):nth-last-child(1)"}}, [RowSelector="TABLE:nth-child(15) > TBODY > TR:nth-child(1) > TD:nth-child(1) > TABLE:nth-child(1) > * > TR"]),
#"Headers up" = Table.PromoteHeaders(#"Table from HTML", [PromoteAllScalars=true])
in
#"Headers up"

[ibarrau]

Hi. Usually scrapping web pages with BrowserContents and Html.Table means you need a gateway to process the M code finding html tags.

Unless you can get your response with Web.Contents I don't think you can get rid of the gateway.

I hope that helps,

[odumna]

Hi, ibarrau
Thank you for response, how can I get other way data from web site?

I just use standart option with web datasource
below is steps I've done
1) Get New source - Web

2) in new window put url

3) switch needed table

As result I get query  like this :
let
Source = Web.BrowserContents("https://www.global-rates.com/interest-rates/libor/american-dollar/usd-libor-interest-rate-12-months...."),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE:nth-child(5) > * > TR > :nth-child(1)"}}, [RowSelector="TABLE:nth-child(5) > * > TR"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}})
in
#"Changed Type"

[ibarrau · Accepted solution]

There is no guarantee you can get data from web site without a gateway. Reading web pages usually has that issue. The Web connector works in many many ways and the automatic refresh it's usually for APIs when the response is a json or xml.

In your case the scrapping code generated by the web connector wizards it's a code that needs a gateway to run. In order to check if you can adapt it, you might need good power query skills to check if there is another way around to the code. If not then you just can't connect without a gateway.

I hope that helps,

[odumna]

Thank you for answer.