Issues with PowerBI Service for auth in Snowflake

Hi Mxd24  - The issue you're encountering with Snowflake in Power BI likely stems from user permissions and the way Snowflake handles authentication and role-based access control. 

The error message suggests that the Snowflake credentials for the affected user are either:

Invalid: The credentials provided (username/password) are incorrect.
Insufficient Privileges: The user's DEFAULT_ROLE in Snowflake or other assigned roles lack access to the required resources (e.g., database, schema, tables, or warehouse).

Since you're using a composite model, Power BI is likely passing each user's credentials to Snowflake during query execution. This means each user must have appropriate access in Snowflake.

Yes, as long as you're using DirectQuery mode or composite models, every user must have appropriate access in Snowflake. Power BI does not cache the data but dynamically queries Snowflake using each user's credentials.

To avoid this:

You could switch to Import Mode, where only your credentials (as the report owner) are used to pull data. Users won't need Snowflake access, but they'll only see the data you imported at refresh time.