A New Workbook Says Saved Datasets or Variables Could Not Be Loaded
A new workbook normally opens with empty Datasets and Variables lists. The add-in automatically retries if Excel does not make workbook storage available immediately.
If the message remains, close and reopen the Astrato task pane. If it keeps happening, share the time of the failure and the Excel version with your support contact.
I Get #NO_DATA
Possible causes:
The dataset does not exist.
The dataset has no matching cached result.
The connection is offline and no cached result is available.
The dataset update mode is Off and it has not been refreshed yet.
Try refreshing the dataset from the task pane.
I Get #LOGIN_REQUIRED
The dataset needs a connection, but the add-in cannot find usable connection details.
Check:
The connection still exists.
The connection name in the dataset matches a saved connection.
The connection has URL, tenant ID, and PAT.
Get #VALUE!
Get #VALUE!
Possible causes:
A formula contains an invalid parameter or variable option.
A parameter override references a parameter that does not exist on the selected measure.
The formula passes an unsupported value.
Check the spelling of parameter names. Parameter names must match the semantic layer measure parameter names.
The Table Does Not Spill
Excel tables from ASTRATO.TABLE spill into neighboring cells.
Make sure the cells below and to the right of the formula are empty.
Changed Connections and the Semantic Layer Disappeared
This is expected.
When a dataset connection changes, the add-in clears the selected semantic layer and dataset definition. A semantic layer ID from one Astrato environment may not exist in another.
Select the semantic layer again for the new connection.
I Do Not See a New Dimension or Field
Open the dataset editor. If the semantic layer was already cached, the add-in shows the cached version first and refreshes it in the background.
Wait briefly and search again. If the connection is offline, background schema refresh is skipped.
Astrato Says the Connection Is Valid but the Data Cannot Be Accessed
Your OAuth login or personal access token is still valid, but you do not currently have access to the requested semantic layer or its data.
Use Check access in Astrato or Open in Astrato from the error message. Confirm that the same data can be opened there, then request the required permissions from the data owner or an Astrato administrator.
You do not need to reconnect unless the add-in separately reports that the connection is invalid.
The Add-In Says Connection needs attention
The identity check confirmed that the saved credentials are no longer valid.
For Sign in with Astrato, open the connection in Settings, sign in again, and retry.
For a Personal Access Token connection, open the connection in Settings, update the token, save it, and retry.
A Shared Workbook Shows Cached Data but Cannot Refresh
Connections are user-specific and are not stored in the workbook.
Another user can see cached results from the workbook, but they need their own connection to refresh data.