Fetching issues
To start working on Jira data you need to Import issues from any of the saved filters (those are filters available for logged in user) or use JQL.
When fetching data from Jira, results are limited to 3000 issues.
When you have data in excel, you can easily change visible columns, reducing the number of visible columns will also increase performance.
As you can see, even after refresh columns stay hidden.
Import issues will also pull metadata from projects - allowing you to create new Jira issues: https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/934019084
At this article you can find answer for following questions:
What is the limit of tickets/issues that a filter can contain to show in Excel 365 connector?
Feel free to tell us what topic should be covered: excel365connector@psc-software.atlassian.net