Power BI dashboard does not update when flow is triggered from PowerApp

[gadgetman4u]

I have a PowerApp say MyApp which has a button that runs a flow MyFlow.  MyFlow runs a flow which takes the output from a web service and saves it to a CSV file in the Azure Data Lake Store.  I have a map in Power BI that reads this CSV file and displays the locations on the map.  

I embedded the Power BI dashboard in MyApp as a tile and it shows in the Power BI dashboard.  However, when I click the button from MyApp, the flow runs and correctly stores the data in Azure Data Lake Store, but does not automatically refresh the map that is in the Power BI dashboard.  I tried to refresh the tile and the data in Power BI, but it doesn't change the locations on the map.  If I go to Power BI Desktop and then refresh the map and then republish the map, then when I go to the Power BI dashboard on the web, then I can see the updated map. 

But I just want to have an interaction that based on the values entered in the PowerApp and the button, it just updates the data and shows the updated data on the Power BI map.  

I've looked at many articles on Power BI embedded and Power BI and PowerApps, but I am confused as to how to achieve this.  Do I need to create a Power BI streaming dataset? 

Appreciate any help on this.

[v-jiascu-msft]

Hi @gadgetman4u,

You should refresh the dataset or set a scheduled refresh of the dataset in your scenario. Because the data had been stored in the data source, but the Power BI dataset didn't get it. If you'd like the real-time effect, the streaming dataset could be the best choice.

Best Regards,

Dale

[gadgetman4u]

Hi Dale,

I've created the real-time streaming dataset in Power BI service, but I can't see it when connecting to the Power BI datasets in Power BI desktop.  Basically, I want to take the real-time streaming Power BI dataset and visualize it in on a map.  In creating a tile in Power BI service, I don't see an option to visualize it on a map.  

Any way for doing this?

[gadgetman4u]

So it seems like if you create a real-time streaming dataset, it only allows you to use the Power BI streaming data tile to connect to it and the visualization does not include a map.  

Therefore, I saved the data into a SQL table using Flow and the data gets updated on the map on the Power BI dashboard but only when the dashboard is reloaded in the browser.  When I click the button on the PowerApp (which is a tile in Power BI), the data does not get updated on the map.  Is there a way that I can automatically update the data on the map without having to reload the entire dashboard page?

Thanks.

[gadgetman4u]

So I'm following this video https://www.youtube.com/watch?v=0YIBHfgasok on live data streaming in Power BI, and on this slide (attached as a screenshot), it says that when the data comes into Azure SQL DB and you have DirectQuery, the Power BI dashboard tile will be refreshsed.  I have a Flow that takes my data and inserts rows into a table in an Azure SQL DB and I also use DirectQuery to that table, but it doesn't refresh the Power BI dashboard tile.

Any reason why?