...
Panel |
---|
panelIconId | atlassian-check_mark |
---|
panelIcon | :check_mark: |
---|
bgColor | #EAE6FF |
---|
|
Useful TipsSet-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
|
Community Resources:
...
Troubleshooting common error messages on Power BI
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. | Image Added | 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 Image AddedThen 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 change the display field of the question causing the error to contain the word {option} as a delimiter
Image Added 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.
| Image Added | Open the Advanced Editor for your query in the Desktop App
Image Added 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.
...