#N/A Showing whereas there are values in the Google sheet

Looker Q&A Looker Studio
1

#N/A Showing whereas there are values in the Google sheet

image
image288×348 2.92 KB

Site Feedback category is for questions or discussions related to the Discourse forum itself. For product related questions or inquiries post in the appropriate Product area (ie: Google Cloud, Looker, AppSheet, Workspace Developers). →

2

Hey,

Hope you’re keeping well.

In Looker Studio, #N/A usually means the source data is returning a value the connector can’t interpret, often from formulas like VLOOKUP or MATCH in Google Sheets that don’t find a match. Check the sheet for those cells and confirm the formula outputs are actual values rather than errors. If needed, wrap formulas with IFERROR to return a blank or default value. After updating the sheet, refresh the data source in Looker Studio from Resource > Manage added data sources to ensure the updated values are pulled in.

Thanks and regards,
Taz