Forum Discussion
Helper IIPower Bi Service Requested a Gateway to Refresh a Web Page Data - Is it Correct?
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
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
4 Replies
- v-diye-msft
Community Support
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
Mp1977Thank you ! I will try and let you know.
kirvisHelper I
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 !