Forum Discussion

JozeM's avatar
JozeM
Frequent Visitor
9 years ago

Web content requires personal gateway - why?

If I publish a report from CSV files on SharePoint OL everything works as expected.

Then I add an external public web source (http://www.geonames.org/countries/) and all of the sudden published report says it can't connect to (required) personal gateway (PG) which is again expected as I haven't got one).

 

Why is PG required in this scenario?

Gateways
Reports

5 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    @JozeM

     

    Power BI team are currently working on improving the refresh of cloud based data sources. As part of this, one of the changes they have made recently is that new datasets that leverage import from Web pages will not be automatically configured for refresh in Power BI service, and will require the use of a gateway. Please consider using the Personal Gateway or On-Premises data gateway if you would like to use this capability. They are working on removing this restriction in the future.

     

    You can keep an eye on this post.

     

    Best Regards,

    Herbert

    • GStrickland's avatar
      GStrickland
      Regular Visitor
      5 years ago

      I've read your blog article and replied there but I thought I would reply here as well. When I select Get Data > Web and look in Power Query I see that the function is already set to Web.Contents. Once I publish to PowerBi service the requires gateway is toggled to on. Using a personal gateway is not a viable option for me. 

  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Hello JozeM 

     

    The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.

     

    And coming to your question we require that gateway as the external source is not a cloud service and it requires a secure transfer of data from the source to the service which is provided by the gateway.

     

    All the data coming from the web requires a personal gateway.

     

    IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!