Forum Discussion
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.
Hi lucplac
If your Power BI dashboards connect to multiple data sources and fail to refresh, it’s often because Power BI needs a gateway when combining sources, especially if any are on-premises. Without an always-on computer for a gateway, you can try using cloud-only sources, simplify your data model, or use Power BI Dataflows or Azure Data Factory to consolidate data in the cloud—these don’t need a gateway. Also, upgrading to Power BI Premium can help with complex refreshes. Gateways are mainly required when on-premises data is involved.