Forum Discussion
Solved
Viewing Realtime Data
On all our meeting rooms with have a device that allows users to book the room. We then have an SQL DB that shows if the device is online, firmware version, etc. To date, I've only worked with...
Hi StuartSmith Well, you could use DirectQuery mode in Power BI to fetch real-time data directly from your SQL database whenever the report is accessed. Another way is to set up a Power BI streaming dataset to push live updates from the SQL database via APIs. For on-demand data retrieval, you could use paginated reports, which refresh every time they are viewed. Ensure an on-premises data gateway is configured if your SQL database is hosted locally.
Hi StuartSmith,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.