Forum Discussion

gadgetman4u's avatar
gadgetman4u
Frequent Visitor
8 years ago

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

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 ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
gadgetman4u
Frequent Visitor
8 years ago

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's avatar
    gadgetman4u
    Frequent Visitor
    8 years ago

    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's avatar
      gadgetman4u
      Frequent Visitor
      8 years ago

      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?