Hi Team,
Could you please help me with this issue:
The fields/dimension are showing up in the explore as they are defined in the view however the fields do not show any data when pulled in the explore. Also, I double checked for other fields from the same view if there is any issue but other fields are populating data. So out of 10 fields/dimension only 6 are populating data.
I have done the following 3 checks from this link - https://help.looker.com/hc/en-us/articles/360023586293-Error-Unknown-or-Inaccessible-Field
Hiya!
My best guess here will be that it is coming from the way explore is made.
Probably this view is not the base view of this explore and can be limited from the results in the main explores. Or there can be some limitations like “sql_always_where” or “always filter” etc.
You can check on the generated sql query in the SQL tab in the DATA tab - this should help to understand what is limiting the results. You can also go to SQL Runner from that SQL tab and make changes to the query and check the results.