cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dali748 Regular Visitor
Regular Visitor

Connected to SQL database, can't setup scheduled refreshes (greyed out)?

I created a report in "Desktop" that connects to a SQL database table, I then published this to "Service" and when I try to setup a "Scheduled Refresh" I noticed it's all greyed out.  Also, the "Data Source Credentials" section is all greyed out too.

 

Within "Desktop" I can refresh the data and it updates and then I have to pulbish this again to "Service" so it shows the latest data but I would like this to happen automatically with "Scheduled Refresh".

 

Does anyone know why this is greyed out for me?  How can I get this to work properly?

 

Thank you!

4 REPLIES 4
Super User
Super User

Re: Connected to SQL database, can't setup scheduled refreshes (greyed out)?

Hi there

In order to refresh On-Premise data, as in your example SQL Server, you will need to install and configure the On-Premise Data Gateway.

Here are details on how to get this done:
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

And to configure SQL Server:
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
luisrh Member
Member

Re: Connected to SQL database, can't setup scheduled refreshes (greyed out)?

I assume your database is on premises.   this will work fine in power bi desktop,  but once you publish to the service in order for it to refresh ,  you must have a Data Gateway installed on premises in order for Power BI service to proxy into your databases.

Do you have a Power BI data gateway installed on your environment.   If you don't then you need to in order to refresh it through the service.

Dali748 Regular Visitor
Regular Visitor

Re: Connected to SQL database, can't setup scheduled refreshes (greyed out)?

 

Thank you for the replies!

 

I ended up installing and registering a gateway, it looked like everything worked properly but an issue I notice is if I try to open up the "On-premises data gateway" software I see the attached error now.  How did everything istall properly and now when I re-open the software I see this?

 

on-premise-gateway-error.PNG

 

I then went to "Service" and under one of my datasets I configured a data source under my gateway cluster and I set the schedule to update daily; please see screenshot below.

 

configured-gateway.PNG

 

Some questions I have:

 

1. Is there a way I can run this now to test and see if my data gets updated on this report?

 

2. Is this going to run properly even though I'm receiving that error when I open up the "On-premises data gateway" software?

 

3. I have other reports that connect to this same database but different tables, do I have to create "new data sources" under my gateway for each other report?  I tried selecting this "Datamart Source" data source for another report and it didn't give me the option.

 

Thank you, again!

 

 

Highlighted
Super User
Super User

Re: Connected to SQL database, can't setup scheduled refreshes (greyed out)?

Hi @Dali748 

 

I would recommend first making sure that the Gateway is installed and you do not get those errors.

 

Possibly try and re-install them again.

 

To answer your questions

1.  You can test it by going into your dataset, then clicking on the three dots and selecting "Refresh Now"

image.png

2. If you get it showing that is successfully installed it should work fine.

3. You can use the same data source if the tables belong in the same dataset.


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,881)