Integrating your CommCare data with PowerBi or Tableau has never been this easy!
- Step 1: Configure your Odata feed (just like you configure a Form or Case Export)
- Step 2: Copy the Odata feed/s
- Step 3: On PowerBi/ Tableau Desktop, select Odata Feed/Odata as your connection type.
- Step 4: Enter your Odata feed/s, and login using your CommCare credentials (Note: If you are using 2FA, specify your API key as the password. Your API Key can be found under you My Account Settings.)
- PowerBi Desktop: Use Basic Authentication
- Tableau Desktop: Use authentication type 'Username and Password'
Useful docs from Microsoft and Tableau:
- The feature requires your web user role to have Full Organization Access.
- If you are using 2 factor authentication, please enter your regular email address and your API Key when PowerBI/Tableau Desktop asks for credentials.
Please watch this space for detailed tutorials and pro-tips!