cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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"

1 ACCEPTED SOLUTION

Accepted Solutions
ankitpatira Super Contributor
Super Contributor

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

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

4 REPLIES 4
ankitpatira Super Contributor
Super Contributor

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

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

Moderator v-qiuyu-msft
Moderator

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

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:

 

q3.PNG

 

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

 

q1.PNG

q2.PNG

 

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
ankitaanchan Frequent Visitor
Frequent Visitor

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

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?

 

rdoughty Occasional Visitor
Occasional Visitor

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

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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 308 members 3,184 guests
Please welcome our newest community members: