cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
briannoyes Frequent Visitor
Frequent Visitor

Power BI Embedded and data latency/refresh

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.

2 REPLIES 2

Re: Power BI Embedded and data latency/refresh

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

jcarville Established Member
Established Member

Re: Power BI Embedded and data latency/refresh

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

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)