Real Time data refresh - Power BI & Dataverse

Hey..

I have a BI report that reads data from tables in Dataverse.

I use the Power BI Pro license and this is how I distribute the report within the organization to the relevant people.
A request was made to enable a refresh rate of the reports in real time.

At the moment I saw that with the PRO license there are 8 refreshes per day, the Premium license allows more refreshes but there is a minimum interval of fifteen minutes between each refresh.
It is not clear to me whether a premium license is required for all employees in the company or only for me who owns the report?

Is there a possibility of a real time refresh rate.. by changing settings or some kind of automation using Power automate?

Would appreciate help,
Thanks