Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

This article explains best practices to be followed to avoid any performance(loading time) issues for Power BI connectors.

Best Practice

  • Avoid any concurrent refreshes, i.e., Avoid refreshing 2 two or more connectors simultaneously.

  • For refreshing the “History” fields, leverage the filter option to further filter history data.

  • In case If there is a lot of data, or if it takes a long time to refresh, you can split the refresh into multiple extracts based on the category or data.

  • Remove unused connector fields from the selection.

  • Limit to the minimal fieldset while choosing the performance-sensitive fields like “Sprint Metrics”, “Remote Links” etc.

  • Limit to the minimal fieldset while choosing heavy data categories like “History”, “Work logs” etc.

...