I've recently started setting up my reports to have a scheduled refresh. I have one report on Power BI that seems to be working fine with the refresh, but I just added a new report and I'm having issues with the refresh. It is connecting to my SCCM Database and I'm not sure if I'm missing privileges and permissions or something else is wrong. The option for enterprise gateway is greyed out even though I've added the dataset and made sure it matches the data source on the Power BI desktop file and the credentials are the same, also this is the SCCM template from PowerOn, not sure if that's important. Any help would be appreciated.
I haven't worked with SCCM database before, but where does it reside? You only need a gateway if the data source is on premises, so perhaps you don't even need the gateway?
Is SQL Server the only data source of the dataset? Based on my test, only when all data source are configured in the same gateway, the gateway can be used to refresh. If it is not your case, you can also try to remove the report and do a re-publish.