Direct Query report not auto refreshing in BI Service even if it works in desktop

[wpf_]

I got my direct query report to auto refresh in desktop, but it does not auto refresh in BI service.  Is there an additional setting I have to do in the service?  I checked the scheduled refresh settings, but it only has frequency of daily and weekly and the time for it.  Currently i set the desktop to auto refresh every 3 minutes.  Any help would be appreciated. Thanks. 

[parry2k]

@wpf_ oh I just replied on how to detect 1st Sunday of the every month.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@wpf_ without premium, the minimum interval is 30 minutes. I don't think you need to change it to 30 minutes, it will automatically refresh after 30 minutes if APR is turned on, just double-check. 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[wpf_]

@parry2k I think you are right.  Becaue before i noticed the page refreshed after some time so i guess that was after 30 minutes and auto refreshed.  But how can I time the refresh so that It refreshes at around the beginning of the hour?  

Btw, separate question but I am trying to fix the timezone when it is published to BI service.  I tried connecting to a web api to get local time zone but would it be better to just manually offset the utc time and set a logic condition to change it when it is day light savings time?  If so what function that can determine if it is the first sunday of a given month?  Thanks 

[v-robertq-msft]

Hi, @wpf_ 

If you used the dataset with direct query mode, you can only set the page refresh intervals for your report. I don’t think you can schedule the refresh time to the beginning of each hour. Here are the restrictions on refresh intervals in Power BI:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#page-refresh...

Best Regards,

Community Support Team _Robert Qin

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

[parry2k]

@wpf_ do you have Power BI premium, if yes, it should work, if not then the minimum refresh interval for NON Power BI premium is 30 minutes.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[wpf_]

@parry2k I dont have premium.  but i thought premium was just necessary for change detection?  But even so I do not see where I can change the refresh to 30 min, or is that done automatically when I enabled auto refresh in desktop?