Forum Discussion
Helper IIConnected to SQL database, can't setup scheduled refreshes (greyed out)?
Responsive ResidentI 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.
Dali748Thank 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?
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.
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!
- GilbertQ
Super User
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"
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.
