Is it possible to use real time data in PBI without using APIs or Power Automate?

[Anonymous]

As per title,
I would like to know whether or not it is possible to avoid using APIs and PowerAutomate when working with real time data.
Thanks in advance to all those who will kindly answer.

[djurecic]

Hi @Anonymous ,

 Yes, this is possible- take a look at Direct Query.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

[Anonymous]

Hi @djurecic and thanks for the reply,
I am aware of the existance of direct query, but requirement is the data should be updated without any input from the user's end. As far as I know, DQ can't satisfy such  requirements, hence why I opted for Streaming Datasets/Pushed Datasets. Please do correct me if I'm missing out on something.