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 get an error message, click the Refresh icon. In many cases this resolves the issue, but not with the one gigabyte (1 GB) size limit error.

Error scenarios

Credential error in the Navigator

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

Clear cache within Power BI (File>options>clear cache) and restart the connector, or

  • Click Cancel and select Refresh (top right).
Authentication error.

If you still receive a credential error after you clear cache, also clear your recent sources. 

  • Select Recent sources
Select recent sources.
  • Select Remove from list
Remove source from list.

Establish the connection to the export again, and your data refreshes.


Credential error in the Power Query Editor(opens external page), or when you reopen a Power BI report or edit a prior data set

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

  • Click 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 1 gigabyte (GB) size limit you'll get this error.
Anaplan connector supports file downloads up to 1 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.