Forum Discussion
Failed refresh - error -2147467259
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
2 Replies
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
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
