Forum Discussion

Abhi007's avatar
Abhi007
New Member
2 months ago
Solved

Invalid credentials Snowflake

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.

Need Help
  • v-hjannapu's avatar
    v-hjannapu
    2 months ago

    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.

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 months ago

    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.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    2 months ago

    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's avatar
      v-hjannapu
      Community Support
      2 months ago

      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's avatar
        Abhi007
        New Member
        2 months ago

        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

         

  • krishnakanth240's avatar
    krishnakanth240
    Super User
    2 months ago

    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's avatar
      Abhi007
      New Member
      2 months ago

      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's avatar
        krishnakanth240
        Super User
        2 months ago

        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