Avoid errors and save time by checking your spreadsheet before fetching data using Validate.
For example, in the spreadsheet below, the header, Revenue, is misspelled as “Rvenue,” resulting in an error "unrecognized dimension" that prevents us from pulling the relevant data because the header can't be identified.
With Validate, quickly spot and fix errors to ensure data accuracy and a successful fetch by following these steps:
1. Select your Range
2. Under Analyze, select Validate
3. Any unrecognized dimensions will populate
4a. To edit the dimension, select the write icon to search and select the correct dimension.
4b. To ignore the dimension (because it doesn't impact your work), select the ignore icon.
See each step illustrated in the video below:
Note: If the validate feature is not available (grayed out), please be sure that both "Allow Fetching Data" and "Allow Publishing Data" are enabled. Once the changes are saved, the Validate feature will become available.