Forum Discussion
Regarding Direct query
AnilKumar ,
DirectQuery can't achieve the above requirement as you describe. It requires schedule refresh or manual refresh in Power BI Service.
You can consider to push data from your database to Power BI streaming dataset, and create a streaming dashboard, which will display live data in visuals without manual/schedule refresh.
There are some blogs for your reference.
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/
https://blog.crossjoin.co.uk/2016/11/08/pushing-data-from-excel-to-power-bi-using-streaming-datasets/
Regards,
Lydia
AnilKumar ,
DirectQuery can't achieve the above requirement as you describe. It requires schedule refresh or manual refresh in Power BI Service.
You can consider to push data from your database to Power BI streaming dataset, and create a streaming dashboard, which will display live data in visuals without manual/schedule refresh.
There are some blogs for your reference.
https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/
https://blog.crossjoin.co.uk/2016/11/08/pushing-data-from-excel-to-power-bi-using-streaming-datasets/
Regards,
Lydia