Forum Discussion
How do we refresh dataset frequently from datasource?
Once data got updated in database, I want to update it in my power BI report as well instantly. Please help me to acheive this.
7 Replies
Hi murali_r
See this link, it will help you https://docs.microsoft.com/en-us/power-bi/personal-gateway
murali_r wrote:
Once data got updated in database, I want to update it in my power BI report as well instantly. Please help me to acheive this.
On refresh&real time data aspect, you can reference
- DirectQuery mode -- the data is always update to date every time users access reports, note the Limitations of DirectQuery.
- Schedule Refresh -- 8(48 for Premium license) times per day in Import mode, which means you can't refresh more frequently more than 8/48 times per day. See Diferences between Direct Query and Import in Power BI.
- An addition to schedule refresh, it is supported to refresh via REST API Refresh dataset. The API shares the 8/48 times limitation.
- Streaming dataset -- very real time, no refresh at all.
Thanks for updates,
with use of your information I can update dataset , but it is not reflected in report automatically where it is viewed . Once reload/refresh the report then only got update. I need whenever the data got updated , it should reflected in UI automatically without reload/refresh page or report. Please update some idea to acheive this.
Hi murali_r
Did you try using Direct Query? See this link: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
It must show information always uptaded. If you want to use Import, you must see the information after the the gateway information changes it status to completed. See this: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-faq
Hope it works for you.
