Invalid credentials Snowflake

[Abhi007]

I am geting invalid credentials in powerbi service, whereas with same credentails I am able to login.There is nothing issue with ID and Password and I am giving it correctly,can anyone help me with it.

[v-hjannapu · Accepted solution]

Hi @Abhi007,

I would also take a moment to thank @krishnakanth240  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

[v-hjannapu]

Hi @Abhi007,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

[Abhi007]

I have found out an Anamoly which was creating this issue :

Power BI Service Accepts : xxxxxxx.us-east-1.snowflakecomputing.com

We need to provide select LOWER(CURRENT_ACCOUNT()); in it.

While Powerbi desktop accepts: xxxxxxx-xxxxxxx.us-east-1.snowflakecomputing.com

First Needs to be current orgganization and next should be account name.

Thta is why this issue was being there

[GilbertQ]

Hi @Abhi007 

Can you please let us know if you are connecting to Snowflake directly through web or if you are going through a gateway? Because as mentioned above the different configuration settings depending on how you are connecting.

[krishnakanth240]

Hi @Abhi007 

Issue might be related to authentication method, gateway configuration or role permission instead username password itself. Verify Snowflake server name in Power BI service matches one used in Desktop, re enter credentials in Dataset settings - Data source credentials and ensure correct authentication type is selected and check whether on-premises gateway is required and properly configured

[Abhi007]

Hi @GilbertQ , @krishnakanth240 , 

Thanks for replying.

Actaully the main scenario is : I tried to connect via powerbi service and snowflake on 5th June, I was able to connect it properly with the same configurations, but I left it as is then on saturday I wanted to create a report but while creating the connection again, it started showing me the issue, while I have not done any changes at snowflake side , I tried many times and it did not worked, but then I thought of giving the same config on powerbi desktop and there I was able to connect properly but I wanted to do it via service but was not able to connect it.

[krishnakanth240]

Hi @Abhi007 

Issue is specific to Power BI service. Try removing existing snowflake connection from manage connections and gateway and recreate it. Also check whether any authentication policies, network restrictions or tenant level changes when the issue started