{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"style":{"value":"none"}},"macroMetadata":{"macroId":{"value":"aeca3535-1265-43b9-9e74-febdfd76a2d1"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"d251857d-a2ae-4b73-ae14-15a93447db6d"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Getting data through PowerBI","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Request OData Feed","type":"text"}]},{"type":"paragraph","content":[{"text":"From the File menu, click “Get Data->OData Feed” or, from the Home menu, click “Get Data->OData feed”","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":576,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":576,"alt":"Getting data from the File Menu","id":"907b7fd3-7d12-48f2-b18b-56eb9bb4a5ce","collection":"contentId-2459664385","type":"file","height":575}},{"type":"caption","content":[{"text":"Getting Data from the File Menu","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":743,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":743,"alt":"home_get.png","id":"ec031cf1-a0c7-44ea-8357-17637680085f","collection":"contentId-2459664385","type":"file","height":476}},{"type":"caption","content":[{"text":"Getting Data From the Home Ribbon","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Provide the URL for your desired resource","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":529,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":529,"alt":"feedurl.png","id":"42ba1998-af5f-47e9-aa41-6ad334a7e658","collection":"contentId-2459664385","type":"file","height":170}},{"type":"caption","content":[{"text":"Entering Feed URL","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Resource URLs are as follows:","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"fc0369bb-a422-465e-9c90-7bea7be8f76a"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Associated Report","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"URL","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Project Spaces","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/domain/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Web Users","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/webuser/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Mobile Workers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/mobileuser/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Mobile Form Submissions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/formsubmission/","type":"text"},{"type":"hardBreak"},{"text":"date range can be provided by providing start and/or enddate parameters, i.e.: ","type":"text"},{"type":"hardBreak"},{"text":"https://commcarehq.org/a//enterprise/api/v1/formsubmission/?startdate=2024-07-01&enddate=2024-07-05","type":"text"}]},{"type":"paragraph","content":[{"text":"Dates must be provided in ‘YYYY-MM-DD’ format, and refer to UTC time. If no end date is provided, the report will pull data up until today’s date. If no start date is provided, the 30 days up until (and including) the end date will be fetched. Currently, fetching more than 90 days worth of data is not supported.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"OData Feeds","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/odatafeed/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Data Exports","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/dataexportreport/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"SMS Usage","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/sms/ ","type":"text"},{"type":"hardBreak"},{"text":"date range can be provided using the same startdate and enddate parameters described in the Mobile Form Submissions section above.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Two Factor Authentication","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/twofactorauth/ ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"CommCare Version Compliance","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/commcareversioncompliance/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"API Keys","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/apikeys/ ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Application Version Compliance","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/applicationversioncompliance/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Data Forwarding","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/dataforwarding/","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[772.0]},"content":[{"type":"paragraph","content":[{"text":"Case Management","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1028.0]},"content":[{"type":"paragraph","content":[{"text":"https://commcarehq.org/a//enterprise/api/v1/casemanagement/","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Provide Credentials","type":"text"}]},{"type":"paragraph","content":[{"text":"If you have not previously specified credentials for the data source, PowerBI will prompt you to configure them. Use your Commcare HQ username, including email. For password, provide the the value of a current API key. If you want to use these credentials across domains, you can leave the specified level as “https://commcarehq.org”. Drilling-down will provide options to restrict which URLs will use these credentials","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":530,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":530,"alt":"Credentials.png","id":"198eabb6-edc1-482d-9309-61b1dadc283a","collection":"contentId-2459664385","type":"file","height":289}},{"type":"caption","content":[{"text":"Entering Credentials","type":"text"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Load Data","type":"text"}]},{"type":"paragraph","content":[{"text":"If the credentials were specified correctly, a screen will be presented with a preview of the data. Click “Load” to load the data, or “Transform Data” to customize columns, modify data types, or perform other customizations prior to load.","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":659,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":659,"alt":"load_window.png","id":"a1d6be3e-88f7-440e-aac0-46c5e3bbd49c","collection":"contentId-2459664385","type":"file","height":494}}]},{"type":"paragraph"}],"version":1}

Browser not supported