Forum Discussion

yyjp's avatar
yyjp
Icon for Helper II rankHelper II
6 days ago

Report displaying Azure SQL Database data with real-time updates

I would like to create a report that displays data from an Azure SQL Database with real-time updates (refreshing every second or every minute). I have managed to implement the following two methods ...
power bi
krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
6 days ago

Hi yyjp​ 

You can use either mirror the database into Microsoft Fabric with Fabric Mirroring for Azure SQL Database then Direct Lake report or Power BI streaming dataset. In both approaches database will read once per change instead of per viewer or refresh. If you want to stay on Pro or Report Server import mode approach is fine for about one minute as one scheduled refresh serves all viewers 

 

  • yyjp's avatar
    yyjp
    Icon for Helper II rankHelper II
    6 days ago

    Thank you for your response.

    I am currently using Fabric, but since I am operating on the F4 capacity, I am concerned about capacity consumption given the high frequency of data reads in this scenario.

    • Are there any alternatives to the Fabric or Pro dashboards you mentioned if I want to implement 1-second refreshes?
    • * Is there a way to achieve 1-second refreshes using Report Server?
    • * Is there a way to automatically refresh the browser display when using Report Server?

    Thank you in advance.