If you’re experiencing an issue where a custom connector in Power BI does not return the complete set of expected records, consider the following points:
- User Permissions: Ensure that the permissions granted to the user account, even if it is an enterprise API user profile, are equivalent to what a standard user would have. An API user’s access to data is determined by the permissions set within the system, influencing the data returned through the API.
- Preview Data Sets: To validate what data should be accessible, utilize the ‘Preview as User’ feature if available in your BI tool. This will allow you to see what records the user is authorized to access and if the records obtained through the API match the expected results.
- Review Filters: Check for any filters (e.g., geographical filters like ‘Location = New York’) assigned to the user profile. Filters can restrict the dataset to specific subsets of records.
- Consult Documentation: Refer to the latest documentation or user guides provided by the BI tool or the custom connector to ensure that the queries are structured correctly and that all necessary parameters and configurations are set to retrieve the full dataset.