Data fetch from databricks in looker studio

When i query a table from databricks - any query that returns more than 1M records doesn’t load all data - it loads random count of rows and it differs each time i open the report and reconnect.

Does anyone know what is the row limit in looker studio free version

i am facing the same issue.

Does anyone even look at these posts?