Report not showing refreshed data?

[ERing]

I have a published report using a Direct Query connection to Snowflake tables. The Snowflake tables are updated daily, however my users are having to manually refresh the dataset in PowerBI to see the new data in the report.

I thought a DQ connection refreshes data "live", so that any new data will be pulled into a report when the report is opened?

What am I missing?

[v-zhangti · Accepted solution]

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

Best Practices For Using Power BI In DirectQuery Mode With Snowflake | by Jerelle Gainey | Snowflake...

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.

[GilbertQ]

Hi @ERing 

By default Power BI caches the last viewed state of the report when it was closed. That is why the users have to interact with the report to see the latest changes.

You could look at implementing the automatic page refresh?

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn