Export time depends directly on how much data your data source includes.
The more objects, fields, and records you select — the longer it takes to process and load in Power BI.
This page covers simple ways to keep your exports fast and reliable.
Limit the Amount of Data #
The biggest factor is data volume.
Try to:
- Select only the objects you actually need
- Avoid including unnecessary fields
- Use filters (e.g., date ranges, owners, statuses)
Instead of exporting everything, focus on the data required for your report.
Split Large Data Sources #
If your data source includes too much data, consider splitting it into smaller ones.
For example:
- Instead of one large data source with all objects
- Create separate ones like:
- Sales Data (Opportunities, Accounts)
- Support Data (Cases)
- Marketing Data (Leads, Campaigns)
This makes:
- Exports faster
- Data easier to manage
- Reports more focused
Adjust Refresh Frequency #
Avoid refreshing data more often than necessary.
- Frequent refreshes increase load on both Salesforce and Power BI
- Large datasets take longer to refresh each time
Choose a schedule that matches your business needs (e.g., daily instead of hourly).
Use Filters Strategically #
Filters significantly reduce export time.
Common examples:
- Date ranges (e.g., last 30 days)
- Specific owners or teams
- Relevant statuses only
Well-defined filters = faster exports and smaller datasets.
Use Incremental Refresh #
Instead of reloading all data every time, you can refresh only new or updated records.
This is especially useful for large datasets that grow over time.
💡 Summary #
To improve performance:
- Keep data sources focused and lightweight
- Split large datasets into smaller ones
- Use filters to reduce volume
- Avoid unnecessary refresh frequency
- Use incremental refresh for growing datasets
