Make sure that the role has permissions for SuiteAnalytics Workbook, Find Transaction, and corresponding Transactions.
For example, Custom Role A user will query list of Sales Orders. The following must be added on the user's role:
- SuiteAnalytics Workbook
- Find Transaction
- Sales Order