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