Access Snowflake using SPN

[dheer1610]

Hi,

I'm trying to connect Snowflake with SPN on power bi service. But to do that I need to generate a token and token validity is 1hr only.

How can I extend the duration or set it different way so, that I don't need to generate token again and again.

Is it possible to use gateway and SPPN to connect Snowfake.

SPN is only allowed in our organisation due to the security policy. 

[v-cazheng-msft]

Hi @dheer1610 ,

I guess that you are getting Azure AD token by using a service principle name, and it should an access token based on Azure AD. To extend the lifetime of the toke of SPN, you may refer to this official document: Set lifetimes for tokens - Microsoft identity platform | Microsoft Docs. You need do it with latest Azure AD PowerShell Module Public Preview Release. But if you would like to use gateway to authenticate to your data source with SPN, which is not supported currently.

Power BI Ideas is a website where our product team will collect the needs and suggestions from users and take them into consideration when designing or improving our product. You may have a look at the following idea in Power BI Ideas, and vote or add your comments with details for it. Thanks in advance!

Link of Power BI Idea that may be useful to you : https://ideas.powerbi.com/ideas/idea/?ideaid=da0d6588-4b7c-45f4-b39b-a70491c483a8

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun