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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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

Comments
v-yetao1-msft
Community Support
Status changed to: Delivered

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 I

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.