When connecting with a 'Dynamics 365 Business Central public cloud (Web Services)' data source, an error can be displayed:
Complete text of error message is:
You do not have the following permissions on TableData What's New Notified: Read
To view details about your permissions, see the Effective Permissions page.
To report a problem, refer to the following server session ID: 'xxxxx'.
There is a virtual What's New Notified table in Business Central public cloud which users are unable to gain Read access to in order to display the record count for that table in the Jet design tools.
Open Excel and navigate to the Jet Data Source Settings.
Select the Display tab on your 'Dynamics 365 Business Central public cloud (Web Services)' data source and uncheck Display table record count.
Click OK to save your settings.