Failed refresh - error -2147467259

[Anonymous]

Hello,

Refresh in PBI Desktop is working correctly, but after upload to PBI Service - I get thie error:

Underlying error code: -2147467259
Underlying error message: 'Role' are not valid Snowflake options. Valid options are: 'ConnectionTimeout, CommandTimeout, CreateNavigationProperties'
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net

I use Snowflake and on-premise gateway and other reports are refreshing just fine.

Thank you in advance for your help!

Marie

[GilbertQ]

Hi @Anonymous 

I would suggest having a look at the connection properties in Power Query it looks like there is something not right with this.

Here are more details on how to connect with Snowflake Connect to Snowflake with Power BI - Power BI | Microsoft Docs

[Anonymous]

Hello,

thank you for your suggestion.

Later I found out source of the issue and sent a ticket to report a bug

https://community.powerbi.com/t5/Issues/Snowflake-connector/idi-p/1775985