If your reports or data sources aren't showing all the information you expect, check the following:
Missing data in reports
Is the data out-of-date?
If the report is missing some recently added data, try refreshing the report data.
Note: You must be an editor of the report to refresh the data.
Is the data filtered?
Edit the report, then click Resources > Manage Added Filters to see if there are any filter properties in the report. If there are, check their setup to make sure that's not the cause of the missing data.
Missing fields in data sources
Is the data source out of sync with the dataset?
If the data source is missing some recently added fields (columns), try refreshing data source fields.
Is your Google Sheets data source missing rows or columns?
If the rows (data) or columns (fields) of your Sheets data source are still not appearing after refreshing the fields as described above, make sure the data source connection includes the proper range and options. You must be the owner of the data source to do this.
- Edit the data source.
- On the left, click EDIT CONNECTION.
- Review the connection options, on the right. Be sure any specified range includes all your data, and that you are including hidden and filtered fields, if appropriate.
Sheets connector options.
Is it a connector limitation?
Connectors that are based on fixed schemas, which include many of the Google product connectors, may not deliver all the fields of the underlying dataset. If your data source appears to be missing fields that you know are in the original product, it's possible that field is not supported in Looker Studio. You can check the issue tracker to see if the field has already been requested, or if not, file a feature request.