Power BI Troubleshooting Data Refresh Errors

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 Power BI Gold licence is active and up to date

Check that the specified app has an active trial or paid subscription. In the example below, the error is being generated by the Sales dataset in the Power BI Service.

You can see on the Fenwick Gold Subscriptions page that the trial period has ended for the Power BI Gold for Sales app.

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.