Forum Discussion
Dynamic Date Table not refreshing on Power Bi Service
Hi, moutinhoabreu
Please reference this part: refresh-and-dynamic-data-sources
In most cases, Power BI datasets that use dynamic data sources cannot be refreshed in the Power BI service. You can open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File.
If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.
If there is no warning, then you can refresh through the gateway.
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.
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