Forum Discussion
Dynamic Date Table not refreshing on Power Bi Service
Hi v-janeyg-msft Thanks for your reply.
No message appears, when opening Data Source Settings.
So i don't understand why its not working. I see several similar cases on the web, with direct query source, where the data table is refreshing.
Thanks.
moutinhoabreu Did you install gateway and set schedule refresh? Is 'refresh now' successful?
Yea, there's a gateway installed, latest version and it's working otherwise the sql direct query would not update automatically.
v-janeyg-msft when you mention schedule refresh I don't understand as in direct query there's no need to setup schedule refresh as we work with live data.
Thanksmoutinhoabreu OK, Have you refreshed the browser cache or page refresh? There may be a delay.
If everything is normal, I think it should be dynamic data sources refrresh restrictions.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Hi v-janeyg-msft Thanks for your reply.
Yes i did cleaned my browser cache. Regarding delay it's excluded because day after day the date table doesn't refresh at all. It remains on last day i pusblished from PBI Desktop.
Its weird as Microsoft annouces Dinamyc date table and in my case it's more Static Date Table. At no point reading the Microsoft documents i see any kind of restrictions for building a M language Dinamyc date table on a Sql On premises direct query.
Thanks anyway for your effort. Lets hope someone can help with my trhead.
Kind regards.