Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 powerbi.com, the credentials used in Snowflake are the same login that was used to publish the report and dataset file.
Our configuration is:
Observations so far:
Any thoughts on what we are missing to have the user queries run with their corresponding Snowflake login?
Solved! Go to Solution.
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.
Yes it is set up like your image.
I am sorry had a miscommunication with a co worker, we were set to "public" for privary level. We now have changed to "Organizational" and get this error when trying to retrieve data:
Hi @cstewrun
I would suggest checking with your Snowflake admin that the calls are getting through to Snowflake?
I checked the snowflake logs and there was no failed logins during this time.
So you could see it getting to snowflake with the right user?
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.