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

Hi cstewrun 

 

I would suggest checking with your Snowflake admin that the calls are getting through to Snowflake?

cstewrun's avatar
cstewrun
Regular Visitor
2 years ago

I checked the snowflake logs and there was no failed logins during this time.

  • 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.