Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2021 Excel 2019 Excel 2016

You may encounter refresh errors when you are working in a workbook with data types. These occur when you either manually refresh or when Automatic Refresh is enabled by the data provider. Automatic Refresh is enabled by default, so these errors may appear even if you haven't tried to refresh anything. See the "Errors and recommendations" section for what causes these refresh errors and how to mitigate them.

Important: You can work around these errors by turning off Automatic Refresh. After the conditions causing the refresh errors are resolved, manually refresh the data types. Note that:

  • Data may become out-of-date if Automatic Refresh is turned off.

  • Manual refresh will fail for the same reasons as Automatic Refresh. You can work with the existing data without encountering errors. Keep in mind that the data may not be fresh.

Where you might see these errors

There are three places you might see these errors.

  • A message bar above the grid

  • A dialog

  • An interactive tooltip

Tooltip example:

ToolTip displaying a Data Type refresh error

Errors and recommendations

ERROR

RECOMMENDATION

We couldn't find this data type. You may not have access to it or the source data may have changed.

Make sure you have the necessary permissions to access the table.

We couldn't link all your data. Please reopen Excel and try again.

Exit Excel, and then open the file again.

You can't access Organization data types. You may not meet the requirements or have the correct license.

Verify that you have an account with a Microsoft 365 subscription and a Power BI Pro service plan.

Something went wrong on our side and we couldn't link all your data. We're working to fix it.

This can be caused by data provider issues. Try again later.

Sorry our server is temporarily having problems. We're working to fix it.

Try again later.

Sorry the service isn't available right now. Try again in a few minutes.

Wait a few minutes, then try again.

This data type is not yet supported.

We can't promise when the requested data type will become available. Consider changing your workbook to use only supported data types.

This feature has been disabled by your Power BI admin. Please contact your Power BI admin for assistance.

Your Power BI admin may be able to enable the feature for you.

Unable to refresh data types.

Try again later.

We couldn't refresh all your data but we've refreshed what we could. Please try again later.

Try again later.

We couldn't refresh the data because the source data or your permissions may have changed.

Verify that you have the necessary permissions to access the Power BI data. Consider contacting the dataset owner (see the bottom of the data types card).

We refreshed some of your data but we couldn't refresh all of it because we changed or removed it on our side. For the data we can no longer refresh we've kept the most recent results.

No action will resume the refresh of affected data, but consider the impact of the change on your processes or the goals and purpose of your workbook.

We were interrupted while refreshing linked data types. Please try to refresh again.

Try again later.

You can't access data types in this workbook. You may not meet the requirements or have the correct license.

Verify that you have an account with a Microsoft 365 subscription.

You don't have permission to edit certain data types. Some data will not be refreshed.

Verify that you have the necessary permissions. If you do not have them, consider obtaining those permissions and then trying again.

You have exceeded the daily request limit. Try again in 24 hours.

Please try again later. It might not take 24 hours before you can retry.

You need to be online to refresh your linked data types. Check your connection and try again.

Verify that you are connected and check with your IT admin if you are not. Please try again once your connection is ready.

You need to install the latest version of Excel in order to use data types.

Please ask your IT admin about installing the latest Excel version so you can try again.

You need to sign in with a subscription account to use these data types.

Ensure that you are currently logged in to your Excel account, and then try again.

You need to sign in with a subscription account to use these data types. Select Excel from the top menu and then select Sign In.

Ensure that you are currently logged in to your Excel account and then try again.

See Also

Automatically refresh linked data types

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.