How do we refresh dataset frequently from datasource?

[murali_r]

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.

[Eric_Zhang]

---

@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.

---

@murali_r

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.

[murali_r]

@Eric_Zhang

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.

[Juramirez]

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.

[murali_r]

@Juramirez

Yes I am using direct query in my report . But no luck.  If any data updated in database table that is not reflected in my report until I refreshed the report. I am getting same issue . I don't know if any configuration need to do in this report. Please help me for this or provide the some other way to acheive this.

[Juramirez]

@murali_r

Did you try testing in your Power BI Desktop or in the Embedded one? Maybe is something wrong with your datasource. You have set your gateway correctly? It is working? Please provide images or info to see this (remeber to post this with mock data)

[murali_r]

 I am trying testing in embeded one . the following screen sort shows my azure datasource connection details. 

 

Please update if anything wrong.

[Juramirez]

Hi @murali_r

See this link, it will help you https://docs.microsoft.com/en-us/power-bi/personal-gateway