Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
1 year ago
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...
General Comment
Need Help
Tips and Tricks
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

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's avatar
    StuartSmith
    Power Participant
    1 year ago

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