Forum Discussion
DirectQuery Auto Refresh Dashboard Every 60 Seconds
I have a request to create a dashboard that auto-updates every 60 seconds. This dashboard will be in a hallway for doctors to see their next cases. I understand that I will need to use DirectQuery....
Hi,
I know this is old thread but Iam curious if you were able to get this working and which approach did you use ? I have a similar requirement of auto refresh every 60 secs with DirectQuery.
Hello binit, any solution you've found? I've tried multiple ways without luck. My last attempt was as follow:
1. Extract the data using Azure Data Factory (pipeline with a REST activity to GET the needed data from a API call into a Azure BLOB json format. This pipeline can be triggered and scheduled every 1min or in seconds.
2. Get the data in Power BI directly connecting to the Azure Blob Storage previous created .json file in previous step
However, Power BI is not auto refreshing even though the source data is being updated every min.