Power BI Embedded and data latency/refresh

briannoyes — Fri, 07 Dec 2018 22:51:05 GMT

We want to use Power BI Embedded to build out an interactive dashboard in a web app (Angular 7 front end), which sounds like the sweet spot for Power BI. But from what I can tell from the docs, the limitations of data refresh and data latency could be a show stopper for us. I know there is the ability to stream real time data to Power BI. But our scenarios is the following:

- User enters data in a table in the application

- Data gets saved to back end via APIs

- We want the charts in the embedded Power BI dashboard or report to update immediately with the newly changed data

So I'm not sure what combination of features we would need to use for this. I know that data refresh has limitations because the Power BI service pulls the data and caches it and can only do that so often (15 min minimum?). We could expose an API to have Power BI pull the data, or we could push the data to it in the form of an event stream if that is the only way to get the real time update of the dashboard/report (and I know there are differences between those two in terms of the options as well, but am not clear on which we should use for our scenario). I also know a custom data connector might be a solution, but haven't found clear information on what limitations on latency we might run into there.

So if anyone can provide me some pointers on what the right path would be to achieve this real time refresh of charts based data being edited within the app, or if it is not possible, would really appreciate it. Any pointers to documentation or articles that show something along these lines would also be appreciated.

Re: Power BI Embedded and data latency/refresh

AnnibalHAbreu — Fri, 01 Feb 2019 13:51:47 GMT

Hi,

You have to push data into your dataset.

We use MySQL and we have not found any other way to make it works as a real time solution

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data

Re: Power BI Embedded and data latency/refresh

jcarville — Mon, 01 Jul 2019 16:27:38 GMT

Hi @briannoyes did you ever look at this further? It sounds similar to a scenario that I am having currently.

topic Re: Power BI Embedded and data latency/refresh in Developer

Power BI Embedded and data latency/refresh

Re: Power BI Embedded and data latency/refresh

Re: Power BI Embedded and data latency/refresh