Forum Discussion

yyjp's avatar
yyjp
Icon for Helper II rankHelper II
13 days ago
Solved

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
  • v-kathullac's avatar
    v-kathullac
    3 days ago

    Hi yyjp​ ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    Regards,
    Chaithanya

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
12 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
12 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.