How to retrieve data from Snowflake database in SSIS

First you need to install SnowflakeDSIIDriver and set up an ODBC data source. You can find more details about the driver and the connection details here https://docs.snowflake.com/en/user-guide/odbc-windows.html

Use ODBC source in SSIS package.

If you find any performance issues due to most of the fields are in "DT_TEXT", then use CASE statement to convert as VARCHAR in SQL command.

Cheers!
Uma

How to get Power BI Report Server (on-premise) Key from purchased Power BI Premium

If you have purchased Power BI Premium, within the Capacity settings tab of the Power BI admin portal, you will have access to your Power BI Report Server product key. This will only be available for Global Admins or users assigned the Power BI service administrator role.

In the admin portal, navigate to Capacity settings, then select Power BI Premium capacity.

Cheers!
Uma