Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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 !
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
Thank you ! I will try and let you know.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.