PBI Service sends different credentials to Snowflake than those entered in data connection settings

[KrisD]

Hi!

Previously I had "Organizational" entered in the Privacy level settings and refreshes of datasets went through as expected. 

Today I was not able to update my datasets although the entered credentials were correct. 

After discussion with backend they saw that the TEST user credentials were being sent to Snowflake even though the PROD user credentials were those entered in the service. 

When I changed from "Organizational" to "Private" the correct user credentials (prod) were sent to Snowflake and my refreshes came through. 

How is it possible that the credentials entered in the PBI service can change when sent to Snowflake? 

Some random bug or by design?

[v-luwang-msft]

Hi @KrisD ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @KrisD ，

Refer the below article ,the article describes the detailed mechanistic process.

https://www.snowflake.com/blog/using-sso-between-power-bi-and-snowflake/ 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien