Power Bi Service Requested a Gateway to Refresh a Web Page Data - Is it Correct?

[Mp1977]

Hi Everyone !

I created a query to pull data from https://bsportsfan.com/le/23114/Esoccer-GT-Leagues-%E2%80%93-12-mins-play/p.2

It worked well in Desktop but in Power BI Service , it requested when I asked to refresh.

Then i changed my code and used Relative Path, because it might be the issue. But I still get the same request to have a gateway installed.

let
    Source = Web.Page(Web.Contents("https://bsportsfan.com", [RelativePath="/le/23114/Esoccer-GT-Leagues-%E2%80%93-12-mins-play/p.2"])),
    Data0 = Source{0}[Data]
in
    Data0

I pulled data from web before and refreesh it using PBI service and it was never a issue. 

Does anyone knows how can I fix that?

Thank you in advance

M. Penner

[kirvis]

Hi,

I ran into the same issues.

I found a workaround, which I describe here: https://community.powerbi.com/t5/Power-Query/WORKAROUND-How-to-use-scheduled-refresh-of-a-web-page-w....

Hope that helps!

Kirvis

[Mp1977]

Thank you, I will try !

[v-diye-msft · Accepted solution]

Hi @Mp1977 

Try either disabling privacy settings or explicitly setting them to organizational. You can do so on the credentials page (for each data source) when you schedule a refresh.

gateway is required for some kinds of web connections (https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources)

Required for .html, .xls, and Access Databases

[Mp1977]

Thank you ! I will try and let you know.