Troubleshooting Data Refresh Errors related to Fenwick Gold for Power BI

While errors are uncommon, certain scenarios might cause one to show when refreshing data sets in the Power BI service.

The following messages might appear when refreshing your dataset:

OData: Request failed: The remote server returned an error: (400) Bad Request. (Exception of type 'Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLDialogException' was thrown.

OData: Request failed: The remote server returned an error: (400) Bad Request. (Cannot delete a record. Current connection intent is Read-Only.). The exception was raised by the IDataReader interface.

Step 1. Check your Fenwick Gold for Power BI subscription is active and up to date

Check that the specified app has an active trial or paid subscription.

See How to Update Power BI App License Subscriptions for more information.

Step 2. Check your Web Services setup

Check that the web services for the specific dataset have been created.

If they do not exist you can create them manually or uninstall/reinstall the app via the extension management page.