Need help power bi services

[adnanarain]

Dear All,

I am getting a data refresh issue and I have connected Open API in power bi desktop which is working fine but when I try to refresh in power bi services I am getting an error. I dont want to use gateway, Can someone please help me to resolve this issue? I am using the following M code to connect to power bi:

let
    Source = Web.BrowserContents("https://gist.github.com/tadast/8827699"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(1)"}, {"Column2", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(2)"}, {"Column3", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(3)"}, {"Column4", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(4)"}, {"Column5", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(5)"}, {"Column6", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(6)"}, {"Column7", "TABLE.js-csv-data.csv-data.js-file-line-container > * > TR > :nth-child(7)"}}, [RowSelector="TABLE.js-csv-data.csv-data.js-file-line-container > * > TR"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"", type text}, {"Country", type text}, {"Alpha-2 code", type text}, {"Alpha-3 code", type text}, {"Numeric code", Int64.Type}, {"Latitude (average)", type number}, {"Longitude (average)", type number}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{""})
in
    #"Removed Columns"

I am getting a following error message in power bi services:

• Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

[v-deddai1-msft]

Hi @adnanarain ,

As far as I know, you do need a gateway in your situation. Every use of the Web connector to get data from an HTML page requires the use of an on-premises data gateway when published to a Cloud service.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[adnanarain · Accepted solution]

This was a static page so I have converted it to excel and uploaded it on one drive and I had another JSON web connector for the exchange rate, in which I have added Relative path and Query parameters to resolve the gateway need, So now its refreshing without Gateway. Thank You

[adnanarain]

Thank you Dedmon for the reply.

I have resolved this problem using relative path and query in M and it's working now without gateway.

[adnanarain]

Anyone please help.