Error: We couldn't refresh because your data gateway (Power BI – personal) is offline...

[Anonymous]

I'm using the Desktop Power BI to publish a Web datasource to the service. When I try to refresh though I get this error:

We couldn't refresh because your data gateway (Power BI – personal) is offline. Make sure your computer is on and the gateway is up and running.

Here's my query:

let
    Source = Xml.Tables(Web.Contents("http:///api/someapi?someelement=value")),
    Table1 = Source{1}[Table],
    Table0 = Table1{0}[Table],
    #"Changed Type" = Table.TransformColumnTypes(Table0,{{"element", type text}, {"element", type text}, {"quality", type text}, {"Attribute:description", type text}}),
in
    #"Renamed Columns1"

[rdoughty]

You should not need a personal gateway. A Web data source is an "off prem" datasource and should refresh by itself in the Power BI Service.

[v-qiuyu-msft]

Hi @Anonymous,

In your scenario, please open the Power BI Service, then click Settings->Datasets, find the dataset used by this report, then expand Gateway Connection tab, check which server is the personal gateway running on like below:

Then you can go to this server, find and open the personal gateway, check whether it's running like below:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[ankitaanchan]

Hi,

I am facing the same issue.

When I am running the Gateway it shows;

It says 'Please wait while we check for few more things' insted of connected.

And in place 'Help improve option' it shows 'Access Denied'

Can you please help me in resolving this?

[ankitpatira · Accepted solution]

@Anonymous Error message suggests you don't have personal gateway running or is accessible. Personal gateway is required to enable schedule refresh of data in power bi service. Follow this article to setup personal gateway.