I would like to create more complex reports in Zoho creator. But the option Query is not available in Creator, only in Reports. So I investigated and found option to integrate Creator and Reports. 

It goes that you have to Publish the report in Creator and then with that URL you can set a Scheduled import in Reports and then based on that create  more complex Queries. 

OK, although not simplest option, I would prefer that Query option is in Creator (why is it not??!). But it works, big problem is that when you publish the data, it goes public. Anyone can see the data. Is there an option that it would be private, and accessed by Reports with password or some key?

Please help, I'm on paid Creator account, Basic one.

Rg Gorazd