cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Power 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.

bsport.png

 

 

 

 

 

 

 

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

1 ACCEPTED SOLUTION
Community Support
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

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

4 REPLIES 4
Frequent Visitor

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

Thank you, I will try !

 

Community Support
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

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Thank you ! I will try and let you know.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors