I need help with this, Iam try different BI intelligence software between Power BI and Zoho Reports, in lasted days i worked with Zoho Reports all intelligence BI of my company and the tool is good for me, but Power BI have something that i dont see of Zoho Report this is something call Gateway, this tool let me do a Direct Query to my database from cloud in real time see tha data of my SQlserver database.

For upload data to Zoho Reports i use ZohoReportsUploadTool_Windows this import an query to the cloud and permit work with the data in this. But when you need read more to one million of rows? and don't like charge with all data your cloud? with Power BI can use Direct Querie with Gateway tool, how do the same with Zoho Reports?

Thanks for you help.