1. Data integration
  2. Third-party data integration
  3. Anaplan Connector Power BI Desktop
  4. Common errors and solutions

You may get error messages. Here are some common scenarios and steps for resolution.

If you do get an error message, select the refresh icon. This resolves the error in most cases.

Error scenarios

Credential error in the Navigator

We couldn't authenticate with the credentials provided, please try again.

To resolve such an error:

    • Select Refresh (top right).
Authentication error. This image shows an arrow to highlight the refresh button.
    • Select File.
    • Select Options and settings.
    • Select Data source settings.
    • Select the permission Anaplan Connector from the list.
    • Select Clear Permissions
    • Select Delete

This removes expired Anaplan API tokens. You must re-authenticate to proceed.

Integration list, display error

Solution: If you do not see your complete list of integrations after you switch your Workspace, you can: 

    • Select refresh button (next to Integrations)
    • Or refresh your browser

      You can also:
    • Select Recent sources
Select recent sources.
    • Select Remove from list
Remove source from list.
  • Connection to the export again.
    Your data refreshes.

Credential errors:

We couldn't authenticate with the credentials provided, please try again.

This error might display:

To resolve this, select either Close & Apply or Refresh Preview.

Power query error.

Your data refreshes.

Close & Apply and Refresh Preview icons.

Power Query Expression(opens external page) error

Expression.Error: They key didn't match any rows in the table.

Click Refresh Preview

Power Query error Key and Table.

The first 1,000 rows of data display. 

Refresh preview.

Large file download error

If you go beyond the 5 gigabytes (GB) size limit you'll get this error.
Anaplan connector supports file downloads up to 5 GB in size.

Error message when a file is too large.

Return to your Anaplan model, decrease the size of your file, and try again.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.