Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |