Forum Discussion

cstewrun's avatar
cstewrun
Regular Visitor
2 years ago
Solved

Powerbi.com not passing credentials to Snowflake

We are trying to use Snowflake security policies and user roles to allow our customers to only see their data through Power BI reports. The issue is when our users access the published report in pow...
Data Protection
Need Help
  • cstewrun's avatar
    cstewrun
    2 years ago

    For users in the our domain their queries run without issue using their login.  When testing customer access where their email domain would be outside (gmail, etc), those users have a login we can see in snowflake but get credentials error in powerbi.com trying to run a report.  We have tested with all (external and internal) having the same SF roles and default warehouse.  When looking at login attempts we do not see the external test user even attempting to login.

GilbertQ's avatar
GilbertQ
Super User
2 years ago

So you could see it getting to snowflake with the right user?

cstewrun's avatar
cstewrun
Regular Visitor
2 years ago

For users in the our domain their queries run without issue using their login.  When testing customer access where their email domain would be outside (gmail, etc), those users have a login we can see in snowflake but get credentials error in powerbi.com trying to run a report.  We have tested with all (external and internal) having the same SF roles and default warehouse.  When looking at login attempts we do not see the external test user even attempting to login.