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.
Super UserTo 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.