cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ryank
Frequent Visitor

on-premises gateway offline but running

I have created a PowerBI model in Desktop app on the same machine where the SQL server is hosted. I have been using Import from the SQL Server so all the data is contained in the pbix file.

 

I now wish to setup a scheduled refresh so the PowerBI model updates with new records as the SQL server gets new data.

 

I have installed the On-premise gateway in the PowerBI web app, and it says Connection Successful under ‘Add Data Source’. But here I am stuck. Do I then go back into PowerBI and click ‘Publish to PowerBI’?

 

If I do that,  the Dataset  shows in PowerBI Web, but how do you make it use the On-premise gateway?

 

At the moment when I go to Settings – Datasets - I am getting the error:

Your data gateway (Power BI – personal) is offline. To set refresh scheduling, make sure your gateway is online.

It says (offline, running)

 

Do I have to change anything in the PowerBI Desktop file? Or what else could I be missing here?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: on-premises gateway offline but running

Hi @ryank you have to make sure that both your Power BI Desktop Filename for your SQL Server Source, and the name you create in the Power BI Service (App) have the same names. They are case sensitive so they have to be identical in how they are named.

 

Power BI - SQL Server Database Screen with Command Timeout.png

As you can see from the Image above for my Power BI Desktop File the Server name is SQLServer, so when I create the dataset on the Web, the name Must be idential for it to work, and to be able to select it.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: on-premises gateway offline but running

Hi @ryank you have to make sure that both your Power BI Desktop Filename for your SQL Server Source, and the name you create in the Power BI Service (App) have the same names. They are case sensitive so they have to be identical in how they are named.

 

Power BI - SQL Server Database Screen with Command Timeout.png

As you can see from the Image above for my Power BI Desktop File the Server name is SQLServer, so when I create the dataset on the Web, the name Must be idential for it to work, and to be able to select it.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

ryank
Frequent Visitor

Re: on-premises gateway offline but running

Awesome, thanks guavaq. It was just the filenames. Working perfectly now. 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Kudoed Authors