...
Navigate to Users / Roles & Permissions
Click +Add Role at the bottom of the page
Provide a name to this role: e.g. Read-Only OData
Unselect all permissions except the ones below:
Export Form Data (if necessary)
Export Case Data (if necessary)
PowerBI/Tableau Integration
Allow role to access data from all locations
Save and assign this role to a user
...
As a reminder, OData Feeds may start to experience performance issues start around 500,000 rows per case or form export configured via the OData feed. Keep an eye on your data usage to ensure you’re not coming up against this threhold.
...
Data Tips & Tricks
Below are some tips in configuring your data in CommCare to work with OData Feeds
...