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