Viewing Realtime Data

[StuartSmith]

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 SP Lists and the restrictive 30min refresh schedule.  I want to create a report that will show the device online status in real time and not having to wait for the data refresh every 30mins.  Is this possible and if so, whats the best approach.

Thanks in advance,

[v-saisrao-msft]

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.

[v-saisrao-msft]

Hi @StuartSmith,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @StuartSmith,
I wanted to check if you had the opportunity to review the information provided by @Akash_Varuna. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Akash_Varuna · Accepted solution]

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.

[StuartSmith]

Thanks, my question relates to the future project and will try your suggestions once the project starts.