Forum Discussion
Power BI Gateway Issue - Snowflake
Hi Team, We are developing a number of Power BI reports using Snowflake as the data source. We are using the direct query mode in the Power BI Desktop due to secuirty constraints and the real time d...
Anonymous Snowflake+PowerBI with directquery is challenging, and one of those challenges is definitely the data gateway. This gateway causes a number of problems, including:
- Reliance on gateway to be up and running
- Lack of visibility into who is running queries from Snowflake query history (everyone appears as the gateway user)
- Inability to control row level security from Snowflake (but it can be handled via roles in PowerBI)
To respond to your specific questions:
1. As ridiculous as it seems, yes that is currently the case.
2. Nope. Only solution is to have your people open the report in PowerBI Desktop, or to have your organization switch to Tableau.