Scheduled refresh not working

To enable scheduled refresh without a gateway, ensure all data sources are cloud-based and supported. However, when mixing multiple cloud connectors like two Salesforce instances, Power BI might treat it as a complex or unsupported combination, leading to refresh failures.

Use a single combined source (e.g., merge the Salesforce data inside Salesforce or use a dataflow).

Move all transformations to Power Query Online via Power BI Dataflows, then connect your dataset to the dataflow.

If mixing is unavoidable, then:

• Install an On-premises Data Gateway (Personal Mode) on a PC that can stay on during refresh times.
• Or, consider using Azure services like Data Factory or Logic Apps to sync data to a single storage location (e.g., Azure SQL or SharePoint), then connect Power BI to that.

Power BI requires a gateway if any of the sources are considered on-premises or if the combination of sources isn't supported natively in the cloud.