...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Important:
|
Performance Considerations:
OData feeds is our entry-level solution for integration with PowerBi and Tableau. It has been optimized for ease of use, so that non technical users can build quick integrations.
However, OData feeds do not support incremental refresh, i.e. each time you refresh, the entire dataset is refreshed. You can mitigate performance issues by publishing the data viz/report from Tableau/PowerBi Desktop to Tableau Online or PowerBI Service, where you can configure the data viz/report to refresh automatically on a schedule defined by you. If you are still unhappy with the performance, please consider using our Data Export Tool to build a CommCare → SQL DB → PowerBi/Tableau data pipeline. Our Data Export tool supports incremental refresh and is designed for enabling performant data pipelines. Performance can vary depending on the data model, but generally speaking we have started to see performance issues start around 500,000 rows per case or form export configured via the OData feed.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Useful TipsSet-up a web user read-only role limited to read OData feeds:
|
...
Error Message and Plausible root cause
...
Example Screenshot
...
Steps to Fix the error
Error:
Unable to connect
Plausible root cause:
A checkbox question could be causing an issue in your feed.
You may need to either de-select the checkbox questions option, or add a delimiter option for the erroring property.
...
Solution 1
Navigate to the feed that is causing the error on CommCare HQ
Click on Copy & Edit Feed button and uncheck the Expanded Checkbox Questions checkbox
Then use the edited feed in the integration with Power BI
Solution 2
...
Navigate to the OData feed that is causing an error on CommCare HQ
...
Click on Copy & Edit Feed button
...
Then use the edited feed in the integration with Power BI
Error:
There was an error processing your dataset
Plausible root cause:
If you have a large number of feeds or data, the request may be timing out.
You may need to increase the timeout period for the query.
...
Then change the settings as follows in the Implementation box for each feed included in your query:
let
Source = OData.Feed("https://www.commcarehq.org/a/[domain]/api/v0.5/odata/cases/[uuid]/feed"", null, [Implementation="2.0", Timeout=#duration(0, 0, 90, 0) ])in
Source
...
Then click on Done once finished with making the changes.
Source: https://community.powerbi.com/t5/Desktop/How-to-set-command-timeout-option/m-p/920420
Bulk delete Power BI/Tableau Integration Feeds
The bulk delete Power BI/Tableau integration feed gives you the option to bulk delete multiple exports at once.
...