Automatically Dataset Refresh Once View is refreshed in source

[Anonymous]

Hi,

I need help, My VIEW refresh in source, every 5 hours once in a day, once it is sucessfully refreshed in source then dataset should refresh automatically in Power BI Service. Is there any workaround for this ?

[Anonymous]

Hi @Anonymous ,

The refresh of the data source you are using cannot be detected yet. But you can consider using scheduled refresh to update the data. If the daily refresh time of the data source is fixed, you can use scheduled refresh, and adjust the scheduled refresh time according to the time when the data source refresh is completed and the time in the refresh history or refresh summary.

For datasets in shared capacity used by Power BI Pro, your Scheduled Refresh action is limited to eight refreshes per day. In Premium capacities, limit 48 refreshes per day.

Note also that the configured refresh time might not be the exact time when Power BI starts the next scheduled process. Power BI starts scheduled refreshes on a best effort basis. The target is to initiate the refresh within 15 minutes of the scheduled time slot, but a delay of up to one hour can occur if the service can't allocate the required resources sooner.

Or consider using REST API.

For Shared capacities, a maximum of eight requests per day, which includes refreshes executed using a scheduled refresh. For Premium capacities, the maximum requests per day is only limited by the available resources in the capacity. If available resources are overloaded, refreshes are throttled until the load is reduced. The refresh will fail if throttling exceeds 1 hour.

Here are some references that may be helpful.

Configure scheduled refresh

Refresh Dataset - REST API

Data refresh in Power BI

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

@tackytechtom  Thanks for reply.

Actually i am using aws simba athna as a data source. we have created views there.

[tackytechtom]

Hi @Anonymous,

If the refresh in your source is part of an ETL process i.e. in a data factory pipeline, you could use this blog post to see how to trigger a dataset refresh in Power BI. It uses the Power BI "refreshes API", so even if you use another tool than data factory you should be able to apply the API syntax from that post.

Hope this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/