Page Comparison

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

1. Navigate to the feed that is causing the error on CommCare HQ

2. Click on Copy & Edit Feed button and uncheck the Expanded Checkbox Questions checkbox

   

3. Then use the edited feed in the integration with Power BI

Solution 2

1. Navigate to the OData feed that is causing an error on CommCare HQ

2. Click on Copy & Edit Feed button

3. Then change the display field of the question causing the error to contain the word {option} as a delimiter
   
   

4. 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.

1. Open the Advanced Editor for your query in the Desktop App
   
   

2. 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

3. 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