Automatic refresh every 15 mins in power BI

[Anonymous]

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

[fe_username]

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.

[Anonymous]

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]

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 · Accepted solution]

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

[Shawn_Eary]

I realize this thread is a bit old, but if the developers happen to be using MS Azure SQL Server, can't they just use DirectQuery and not have to refresh anymore?
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

My problem is that I'm using Azure Table Storage and I don't think DirectQuery is supported for Azure Table Storage right now. Also, as of today, there doesn't seem to be a Flow/PowerAutomate connector for Azure Table Storage as far as I can tell, so I will likely have to update my Azure Functions to copy parts of my Azure Table Storage data into a Power BI Push Dataset...