Versions Compared

Old Version 61

changes.mady.by.user Krinda Wernicke

Saved on

compared with

New Version 62

changes.mady.by.user Gillian Javetski

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
panelIconIdatlassian-check_mark
panelIcon:check_mark:
bgColor#EAE6FF

Useful Tips

Set-up a web user read-only role limited to read OData feeds:

  • 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

...

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

  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

    Image Removed

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

...