Embedded Dashboard not Returning the same Results

brittany-163761 · 03-04-2022 02:03 PM

Hi there, first post in this community. My company has newly implemented Looker and we are running into an issue with an embedded dashboard that recently went live. The dashboard itself has 3 table tiles all based off the same explore just surfacing slightly different data.
One of these tables returns rather efficiently and with the correct data, the other two queries ‘complete’ in under a second(According to the Queries list in the admin panel) and return ‘No results’. When I load the same dashboard in Looker it returns the correct results in all three table tiles.
I’m at a bit of loss here and I’m wondering if anyone else has run into a similar issue and would be able to advise on a solution or even some testing that could narrow down the problem.

Thank you!

svickers

Could it be an issue with the embed user attributes/permissions? If you see the query details you can get the actual SQL statement that was executed. Copy that and run it directly in your SQL console of choice and see if data is returned or it really does yield 0 records.

brittany-163761

I have grabbed the query that was executed and run it in SQL Runner. It returns the expected results when run in SQL Runner. The user attribute is the same one used for the table the runs correctly