Overview
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 or more connectors simultaneously.
For refreshing the “History” fields, leverage the filter option to further filter history data.
In case 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.