Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Do we need gateway for refreshing data from Web

Hi Folks, I have extracted data from a web URL into a Power BI desktop file and published this report on Power BI Service. Can anyone of you tell me if I will need a gateway to schedule auto-refresh...
Need Help
  • RenuKshirsagar's avatar
    RenuKshirsagar
    6 years ago

    Hello Anonymous ,  

     

    We don't require gateway when the data sources are cloud (SharePoint Online, OneDrive). You just need to configure your credentials as shown in the following image.  

    A gateway is required when we connect to Wikipedia from Power BI Desktop. I connected to Wikipedia and I am asked to install a gateway.  

    WEB DataSource: OneDrive & SharePoint

     

     

     

    If this was helpgul, kindly promote this as a solution.

     

    Thanks,  

    Renu KS.

     

  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    As I posted before, when the URL is of a Wikipedia page, it needs to configure a personal gateway / a enterprise gateway to refresh data in power bi service. When you have no gateway, power bi service will remind you to install. Without gateways, it will not refresh automatically because you could not configure a scheduled refresh for it.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

As your mentioned, when you get data from the cloud like SharePoint or OneDrive for Businesss etc, it need not gateway when refreshing it. However, when you ger dafa from wikipedia etc, it needs a personal gateway / enterprise gateway.

When you refresh it without personal mode gateway, power bi service will remind you to install a personal gateway to enable to edit data credentials.

Or you can use an enterprise gateway to add a new data source for each web URL to refresh them.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank for helping me out. I understood this for sharepoint or cloud owner by Microsoft. But what is URL is of a Wikipedia page. Does that also refresh automatically without gateways?

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    As I posted before, when the URL is of a Wikipedia page, it needs to configure a personal gateway / a enterprise gateway to refresh data in power bi service. When you have no gateway, power bi service will remind you to install. Without gateways, it will not refresh automatically because you could not configure a scheduled refresh for it.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.