Snowflake tables to power bi

[bzeeblitz]

We have only read access link to the snowflake so how to connect to power bi.our challenge is we have only limited previliges to snowflake thats only read only access to snowflake so how to handle this challenge 

[V-yubandi-msft]

Hi @bzeeblitz ,

Thank you for the valuable insights, @Akash_Varuna .

To add some clarity since you have read only access to Snowflake, you can still use Power BI effectively without needing admin rights.

Here a simplified version of the steps.

1.  Use Get Data Snowflake in Power BI.
2.  In the Advanced options, write a custom SQL query. This eliminates the need to create views directly in Snowflake.
3. Once imported, apply any filters or transformations using Power Query.
4.  For handling large datasets, consider using DirectQuery mode so that queries run live within Snowflake.
5.  If you’re preparing data for multiple reports, you might want to use Power BI Dataflows.

Power Query Snowflake connector - Power Query | Microsoft Learn

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Akash_Varuna]

Hi @bzeeblitz 

• Install the Snowflake ODBC driver.
• Use Get Data > Snowflake in Power BI, enter the server URL, and provide your credentials.
• Write SQL queries directly in Power BI to filter or aggregate data since you can't create views in Snowflake.
• Ensure query folding is enabled to push computations to Snowflake.
• Use DirectQuery to connect live for large datasets instead of importing data.
• You could also use Power BI Dataflows to preprocess and organize data before bringing it into Power BI.
  If this post helped pease do give a kudos and accept this as a solution
  Thanks In Advance

[bzeeblitz]

Challenge is that we don't have enough access to update or modify in snowflake database. So please suggest how we would able to query snowflake as we don't have admin previliges,we are unable to do data manipulation. Kindly assist 

[Akash_Varuna · Accepted solution]

Hi @bzeeblitz Could you try these if this is feasible 

• Write SQL queries in Power BI to filter and aggregate data before importing.
• Use DirectQuery to handle computations in Snowflake without importing large datasets.
• Perform transformations in Power Query after fetching the data.
• Consider using Power BI Dataflows for preprocessing data.