cancel
Showing results for 
Search instead for 
Did you mean: 

Snowflake connector

Hello,

 

recently I have connected to new datasets by Snowflake connector. In the Desktop, there is everything okay. But after upload to the Service, I have got this error:

Underlying error code: -2147467259
Underlying error message: 'Role' are not valid Snowflake options. Valid options are: 'ConnectionTimeout, CommandTimeout, CreateNavigationProperties'

 

Later I realized it was caused by this part of Power Query which was automatically created:
Source = Snowflake.Databases("name_of_database", "name_of_warehouse", [Role=null, CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null])

Thank you in advance for correcting this issue!

Marie

Status: New
Comments
v-lili6-msft
Community Support

hi

The Snowflake connector supports Custom Roles beginning with the February 2021 release of Power BI Desktop.

https://powerbi.microsoft.com/en-us/blog/power-bi-february-2021-feature-summary/#_Toc63074806

 

please input the role name or try to delete "Role=null," in power query then test it again.

 

also have a look this:

https://docs.snowflake.com/en/user-guide/oauth-powerbi.html#using-any-role-with-power-bi-sso-to-snow...

 

 

Regards,

Lin

vineetpatil86
Frequent Visitor

Hi @vitova_bootiq ,

 

Was it resolved?

For my case if I remove the Roll=null then it works, but if I put Role name which is being assigned to mein snowflake then too it provides same error!

Also checked below link and admin has put 

external_oauth_any_role_mode = 'ENABLE'

so in this case it should work after specifying the Role value, but still gives same error!

https://docs.snowflake.com/en/user-guide/oauth-powerbi.html#using-any-role-with-power-bi-sso-to-snow...

Any thoughts/suggestions  @v-lili6-msft