topic Re: How do we refresh dataset frequently from datasource? in Developer

How do we refresh dataset frequently from datasource?

murali_r — Thu, 23 Nov 2017 15:29:57 GMT

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.

Re: How do we refresh dataset frequently from datasource?

Juramirez — Thu, 23 Nov 2017 17:56:27 GMT

Hi @murali_r

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

Re: How do we refresh dataset frequently from datasource?

Eric_Zhang — Fri, 24 Nov 2017 01:50:18 GMT

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

Re: How do we refresh dataset frequently from datasource?

murali_r — Tue, 28 Nov 2017 07:05:41 GMT

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

Re: How do we refresh dataset frequently from datasource?

Juramirez — Tue, 28 Nov 2017 15:18:31 GMT

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.

Re: How do we refresh dataset frequently from datasource?

murali_r — Tue, 28 Nov 2017 17:10:40 GMT

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

Re: How do we refresh dataset frequently from datasource?

Juramirez — Tue, 28 Nov 2017 17:31:21 GMT

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

Re: How do we refresh dataset frequently from datasource?

murali_r — Wed, 29 Nov 2017 09:42:49 GMT

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

Please update if anything wrong.