I have created a power bi report in our on premise server. This uses directquery to connect to the db. Presently, user needs to click the refresh button to see the data when changed in db.
I would like to know whether it is possible to auto refresh the report without any user interaction. I know we could use certain extensions to do this. But it will be nice if we could do this from the report server itself.
I found the following article regarding auto refresh, but I don't see these options. Any help is greatly appreciated.