Power bi to snowflake connection not working with dataflow or service

[rohtashgoyal]

We are able to direct connect to snowflake using power bi desktop but not working with dataflow or power bi service.

we are getting error code 400, invalid username and password, but same credential working fine when try with Power bi desktop.

and use with gateway.

Thanks

[v-yalanwu-msft]

Hi, @rohtashgoyal ;

Connecting to Snowflake in the Power BI service differs from other connectors in only one way. Snowflake has an additional capability for Azure Active Directory (AAD), with an option for SSO. Parts of the integration require different administrative roles across Snowflake, Power BI, and Azure. You can also choose to enable AAD authentication without using SSO.

BTW, it seems like power bi request can't achieve to your gateway, please double check on your database and gateway status.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake

https://www.cdata.com/kb/tech/snowflake-powerbi-dataflows.rst

Or can you share the screenshot about the error datails?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.