About Powerbi Embedded Reports Scheduled Refresh

Question

We are planning to publish our powerbi reports in our sub-domain as a product for our customers. Our reports are refreshing on scheduled manner as new data arrives; hourly, daily, or per 3 hours (or live) etc. We initially tried to use 'publish to web' option, but we realise there is about one hour to see updates on published reports. We need it to be updated as scheduled update occurs.

We are considering to use embedded reports, but we could not find too much any information about how it refreshes. (we are using mysql as datasource for most of our reports)

Can we use embedded reports for that aim? Would it be refreshed instantly as we scheduled refresh our dataset/reports? Or are there any seperate methodology for refreshing embedded reports?

Answer 1

Please refer my article which explains about the data-set refresh manually and also using the WebAPI services https://snkrishnan1.wordpress.com/2018/07/07/powerbi-dataset-refresh-using-net-webapi-service/

Answer 2

Power BI Embedded reports' data refresh is subject to how you define the refresh policy in Power BI. You can define a Scheduled Refresh (up to a limit defined by your capacity) or you can trigger a Refresh Now API call as described here: https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

As for the report's data, once the dataset is refreshed, any new render of the report would show the updated data. If during the same session, you'd want to refresh the view of the report (by knowing that it has newer data) you can always call the Javascript SDK's report.refresh() call on the report. https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embedding---Basic-interactions#refresh-a-report