Optimize the offline profile

There's a lot to keep in mind when you create or update an offline profile for model-driven apps. An offline profile should include all the data that app users need to complete tasks in the field. If it includes too much data, however, app users might get stuck waiting for their data to download. They may even run out of space on their device. You'll need to consider the devices and data plans your app users have to make sure they have a great experience.

The following guidelines will help you create an offline profile that meets the exact needs of your organization.

Don't make your users download too much data

Each user may have access to a different set of data. It's important to think about and test how much data different groups of users will see. For example, a group sales manager might have access to many more sales opportunities than a local sales manager.

As you develop your offline profile and test with real or representative data, keep these best practices in mind:

• Limit the number of records to less than 200,000 for better performance. Exceeding 3,000,000 records is not supported by the offline sync.
• Limit the number of tables to fewer than 100.
• Limit the total data size to less than 1 GB.
• Limit the total files and images size to less than 4 GB. Apply filters to reduce the total download size.

If your app's offline data exceeds these recommendations, users will see slower syncs, higher data utilization, higher battery usage, and slower app performance.

Optimize your offline profile

Apply the following best practices to make sure that users download only the data they need. Optimizing the data that's downloaded will make it easier to stay within the recommended limits.

Don't reinvent the wheel

If you're customizing Field Service or Sales, start from their default offline profiles. You know core features will work, and you won't miss tables that are used in standard forms.

The default offline profiles include everything you need for an out-of-the-box solution. You can add more tables that are important for your business.

But don't remove tables from the default profile. Without those tables, forms or views may fail at runtime. If the default profile includes too many or too few rows of data, adjust the filters on the largest tables to optimize data sizes for your users.

Add all tables that are referred to in each form and view in your app

When you add a form or view to your model-driven app, look for references to other tables, including lookups. Make sure each of these tables is included in your offline profile with a corresponding related table or filters. Be sure to add all tables used in web resource scripts as well.

When you add a table to the offline profile, you can choose one of four options to determine which rows will be downloaded:

• Organization rows
• All rows
• Related rows only
• Custom

To choose the best option for each table, consider which of the following categories your table belongs to:

1. Standalone tables: Tables that are visible as grids in the app, like Contact

2. Related tables: Tables that are referred to in the form or grid view of a different table, like Unit

3. Resource tables: Tables that contain resource data, like Currency or Territory

Choose a row option based on the category of table you add:

Use filters to reduce the data download size

If users have access to a large set of data when they're online, apply filters to restrict the data that they'll download when they're offline.

• Standalone tables: Use a custom filter that includes the records that are required for the grid views in your app. By default, all views are included when you add a table in the app designer. To make sure that users have the same data online and offline, explicitly select the views that filter data that you include in the offline profile.

  

• Related tables: Use a custom filter if you want users to download rows that are related AND that match your other filter criteria.

  

• Resources tables: Use a custom filter if you want users to download only rows that match your criteria, like rows with an Active status.

  

Common custom filters

Filter by time and date fields for time-centric data like bookings and timeline items. Consider both future and past dates. For example, a common filter might include appointments from the past month and the next three months.

Filter by status to limit downloads to rows with a certain Status.

Filter by custom category or role fields to scope large tables down to the data needed for your app. For example, you could filter Contacts by Role to limit data to stakeholders.

Avoid these filter pitfalls that can slow down your downloads

If a custom filter results in a slow Dataverse query, downloads will take longer. Follow these best practices to avoid common performance bottlenecks:

• Don't use partial string matches or "Contains," "Begins with," or "Ends with."

• Avoid multiple levels of relationships in custom filters. Filters like this can lead to slow downloads:

  

• Avoid using many OR conditions.

Optimize dowloaded data with Offline Table Column Selection (Preview)

The first sync can take time to complete for organizations with very large datasets, especially in remote areas. With Offline Table Column Selection (Preview) you can select the columns to download on the device to avoid downloading columns that are never used in the app. This saves both network and disk usage and results in faster sync time. While this impacts both the first sync and delta syncs, the first sync should see a greater impact as there are more records to download.

1. In Power Apps Studio, in the left side panel, select Apps.

2. Select your model-driven app, and then select Edit.

3. Select Settings.

4. Select General.

5. In the Select offline mode and profile section, select Edit selected profile from the dropdown menu.

6. The Edit Profile pane appears. In the Data for offline use section, for the table you want to optimize, select the More actiongs (...) icon, and then select Eddit.

7. The Edit Account pange appers. In the Selected columns section, select the Manage columns option.

8. In the Managed selected columns pane, select the Select only required columns option, and then select more columns, if requried.

   Important

   If you have custom JavaScript code in the app, make sure that the columns used in the custom code are selected in the offline profile.

9. Select Back.

10. Select Save.

11. Select Save + close.

12. Close the Settings and select Publish.

See also

• Best practices to use an app for offline
• Configure model-driven apps for offline (preview)
• Configure offline data for the Field Service (Dynamics 365) mobile app (contains video)
• Five tips for implementing the Field Service (Dynamics 365) mobile app (blog)