Forum Discussion
Schedule Refresh - PowerBI service Dataset not being updated
- Hi there
Based on your images you are connecting directly to the Snowflake DB
Under the section "Scheduled Cache Refreshing" it says that it has a direct query to the underlying database. This shows that it is not importing any data. And that is why you are not getting those options as you would when importing data.
Super UserThe scheduled cache refresh only applies to the Dashboard items.
If you are using a Power BI report you either have to refresh the page or use the new Change Detection feature which is available in Power BI Desktop and Power BI premium.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2020-feature-summary/#_APR
Hi GilbertQ
Thanks for your response. This is a PowerBI report that I published as usual. So, is there something specific to the Import mode or snowflake as data source which is preventing the "Scheduled Refresh" to show ?
When I publish a report with SQL server DB table as a datasource on Import mode, "Schedule Refresh" shows up. This is our first report pointing to Snowflake as the datasource.
Regards,
Chandana Basani
- GilbertQHi there
That is because you are using a direct query to snowflake.
Each time you interact with the report it gets the latest information. No data is imported/stored in your PBIX.Hello GilbertQ
Thanks for the response. For all my tables in the report I chose Import. None of them are direct query.
So for my problem here, where the data in the report (import mode) is not being updated whatever I do in PowerBI service - refresh now (on demand), schedule cache refresh, refresh the browser, refresh the report on refresh icon - what is the option, please suggest.
I will try page refresh and detect any change new feature but I am not sure yet that would solve. I will update here in the chain.
Just to clarify, It is not direct query but import connectivity mode to Snowflake DB.
Regards,
CB
- GilbertQHi there
Based on your images you are connecting directly to the Snowflake DB
Under the section "Scheduled Cache Refreshing" it says that it has a direct query to the underlying database. This shows that it is not importing any data. And that is why you are not getting those options as you would when importing data.