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,
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.