Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Automatic refresh every 15 mins in power BI

Hello,

I have some data in SQL that I would like to set up dashboards for a screen in the factory that continually updates (or at least every 15 minutes). PowerBI won't work for this due to the frequency. Is there a way to refresh it continually or at least every 15 min in Power BI service?

Some way suggested to me for d3.js. Is that the only way or a better one?
Can you please me explaining this as well?

Shubs

General Comment

Tips and Tricks

Anonymous
7 years ago
Here's a link for the Flow approach - https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

5 Replies

Anonymous
Not applicable
7 years ago
Hi Anonymous,
You can try refreshing manually using Microsoft flow or using an API call. In those cases there are no limitations as to how many times you refresh, as those are not counted against the automatic refresh daily limits.
- Anonymous
  Not applicable
  7 years ago
  Hi Anonymous ,
  
  Thanks for your response. Sorry for the delay response. Can you please elaborate on how I can do that with Microsoft Flow or API call?
  
  I am fetching data from SQL and importing the data into Power BI Desktop.
  - Anonymous
    Not applicable
    7 years ago
    Here's a link for the Flow approach - https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
fe_username
Helper I
3 years ago
If anyone is still wondering how,
there is the possibility to have a 15 minutes refresh using direct Query on your PowerBI Dashboards.
Click out from any visual and you will see an icon with a "brush Icon", you can find a ribbon that has "automatic Refresh" and click ON, set 15 minutes and it will do in your powerBI Desktop.

My data is in a sql pool, so I don't know how to handle Azure Table storage.