Post_ID variable not working

Hi, this is my first time creating a topic here.

I am using the WordPress business intelligence lite version checking it out to see if we buy the enterprise version. I tried using the variable of {{{post_id}}} but never returns any values. UI used the example that your website uses and that does work using the {{{user_id}}} variable.

This is the query I am using which is not working I suppose that the query should be on a page which is but still returns 0 rows:
select * from wp_posts where id={{{page_id}}}