Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0

Power BI Desktop to Snowflake authentication

Although Power BI Desktop has the option for users to provide the role name for connecting to Snowflake, it give authentication error message when any other role than the default role of the user is provided.

 

Users should be able to connect to Snowflake from Power BI desktop specifying any role name that is assigned to the user in Snowflake.

 

Durlov_0-1684409972065.png

 

Status: Delivered
Comments
Anonymous
Not applicable

Hi @Durlov 

If you can make sure other account can access the Snowflake DB directly , you can choose the Snowflake and enter other credentials .

Message from Monte Carlo (montecarlodata.com)

vyetao1msft_0-1684475723633.png

Best Regards,
Community Support Team _ Ailsa Tao

DarinSpence
Helper II

You shouldn't need to specify the Snowflake Role.  However, check that the Snowflake User record must have a Default Role Assigned that has been granted priviledges on the the database you are connecting to.