Forum Discussion
PowerBI with Snowflake released refresh error: 'Implementation' are not valid Snowflake options.
Hi SteveShen ,
This is a classic version mismatch between your Power BI Desktop and your On-Premises Data Gateway.
Here is exactly what is happening:
Your Desktop: You are on the November 2025 release (v2.149). This version introduced a newer Snowflake connector (Implementation 2.0) likely for better performance using Apache Arrow.
Your Gateway: The Gateway installed on the server is likely an older version that does not yet recognize the Implementation="2.0" parameter. That is why it lists the "Valid options" and Implementation is missing from that list.
How to fix it:
Option 1: Update the Gateway (Recommended) Ask your IT or Admin team to update the On-Premises Data Gateway to the November 2025 (or latest) version. Once the Gateway matches your Desktop version, it will understand what "Implementation 2.0" means.
Option 2: The Quick Workaround (Edit M Code) If you cannot update the Gateway immediately, you can force the report to use the legacy connector:
Open Power Query Editor.
Select your Snowflake query and open the Advanced Editor.
Locate the part Snowflake.Databases("...", "...", [Implementation="2.0"]).
Simply remove the [Implementation="2.0"] part so it looks like Snowflake.Databases("...", "...") or just Snowflake.Databases("...", "...", []).
Publish the report again.
The Gateway should accept the request since it defaults to the old implementation.
Hope this gets your refresh working again!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Hi SteveShen ,
This is a classic version mismatch between your Power BI Desktop and your On-Premises Data Gateway.
Here is exactly what is happening:
Your Desktop: You are on the November 2025 release (v2.149). This version introduced a newer Snowflake connector (Implementation 2.0) likely for better performance using Apache Arrow.
Your Gateway: The Gateway installed on the server is likely an older version that does not yet recognize the Implementation="2.0" parameter. That is why it lists the "Valid options" and Implementation is missing from that list.
How to fix it:
Option 1: Update the Gateway (Recommended) Ask your IT or Admin team to update the On-Premises Data Gateway to the November 2025 (or latest) version. Once the Gateway matches your Desktop version, it will understand what "Implementation 2.0" means.
Option 2: The Quick Workaround (Edit M Code) If you cannot update the Gateway immediately, you can force the report to use the legacy connector:
Open Power Query Editor.
Select your Snowflake query and open the Advanced Editor.
Locate the part Snowflake.Databases("...", "...", [Implementation="2.0"]).
Simply remove the [Implementation="2.0"] part so it looks like Snowflake.Databases("...", "...") or just Snowflake.Databases("...", "...", []).
Publish the report again.
The Gateway should accept the request since it defaults to the old implementation.
Hope this gets your refresh working again!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Hey burakkaragoz , I ran into this issue as well and removed the Implementation 2.0 parameter as my IT dept is very restricted and could be a long time before they update the gateway. This worked for allowing the refresh to continue but it looks like columns of DATETIME format are now broken. Have you seen this issue before?