Is Snowflake refresh from the PBI service limited to 1000000 (1 Million) rows?

[Anonymous]

I have scheduled a refresh (Import Method, not Direct Query) from a Snowflake table with 32 million rows, but only the first 1 million are coming through.

The refrehsh took 17 minutes and provides a completed successfully message.  The number of recrods is suspiciously 1 million.

[v-yuta-msft]

@Anonymous ,

Please check if the dataset has been up to the dataset limitation:

Capacity type	Maximum dataset size
Shared, A1, A2, or A3	1 GB
A4 or P1	3 GB
A5 or P2	6 GB
A6 or P3	10 GB

Regards,

Jimmy Tao

[Anonymous]

Dear @v-yuta-msft  I have Power BI Pro and  my personal storage shows that I have used 25 MB of 10 GB of personal storage.

However I was able to reproduce this behavior in the Power BI Desktop application. So my issue is not related to the service. I also tested to isoloate Snowflke and I can return all 1.1 Million rows into another database application.

However with the Snowflake connector I am only able to pull 1M rows into the desktop application.

[v-yuta-msft]

@Anonymous ,

I would suggest you create a support ticket here.

Regards,

Jimmy Tao

[Anonymous]

Found the issue inside my Snowflake account configuration.

The"ROWS_PER_RESULTSET" parameter was set to 1M.

https://docs.snowflake.net/manuals/sql-reference/parameters.html#rows-per-resultset

https://docs.snowflake.net/manuals/sql-reference/sql/alter-account.html

Thanks for your support.