Forum Discussion
Report not showing refreshed data?
Hi, ERing
A Direct Query connection to Snowflake tables should indeed refresh data live, as long as the connection is configured properly. There are a few possible reasons why your report is not showing the updated data:
You may have set a query caching option in Power BI that prevents the queries from being sent to Snowflake every time the report is opened. You can disable this option by going to File > Options and settings > Options > Current File > Data Load > DirectQuery and unchecking the box that says Allow query caching for DirectQuery.
You may have used an ODBC connection to connect to Snowflake, which does not support DirectQuery mode. You should use the Power Query Snowflake connector instead, which allows you to specify the server and warehouse names and other advanced options.
Power Query Snowflake connector - Power Query | Microsoft Learn
You may have a data modeling issue that affects the performance of the queries that Power BI generates. You should follow the best practices for using Power BI in DirectQuery mode with Snowflake, such as using a star schema, creating a dedicated warehouse, and optimizing the SQL statements.
Read and write data from Snowflake - Azure Databricks | Microsoft Learn
PowerBI + Snowflake: ODBC Connection: DirectQuery - Stack Overflow
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, ERing
A Direct Query connection to Snowflake tables should indeed refresh data live, as long as the connection is configured properly. There are a few possible reasons why your report is not showing the updated data:
You may have set a query caching option in Power BI that prevents the queries from being sent to Snowflake every time the report is opened. You can disable this option by going to File > Options and settings > Options > Current File > Data Load > DirectQuery and unchecking the box that says Allow query caching for DirectQuery.
You may have used an ODBC connection to connect to Snowflake, which does not support DirectQuery mode. You should use the Power Query Snowflake connector instead, which allows you to specify the server and warehouse names and other advanced options.
Power Query Snowflake connector - Power Query | Microsoft Learn
You may have a data modeling issue that affects the performance of the queries that Power BI generates. You should follow the best practices for using Power BI in DirectQuery mode with Snowflake, such as using a star schema, creating a dedicated warehouse, and optimizing the SQL statements.
Read and write data from Snowflake - Azure Databricks | Microsoft Learn
PowerBI + Snowflake: ODBC Connection: DirectQuery - Stack Overflow
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.