SSAS cube processing error about column binding

Question

This is an error message I get after processing an SSIS Cube

Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated.

However, it gives me no indication of what column binding is too small.

How do I debug this?

Answer 1

1. Open your SSAS database using SQL Server Data Tools.
2. Open the Data Source View of the SSAS database.
3. Right click an empty space and click Refresh
4. A window will open and show all changes to the underlying data model.

Documentation