Refresh Dataset and Refresh Visual questions

I am testing a Power Automate Flow in my dataset. 

My dataset is in Import Mode as I have to use SUM() on large numbers of columns in the database. 

I can run the Flow to refresh the dataset, and this works as verified here:

The issue is that, to the user it looks like nothing has happened after clicking the button. I believe they would then have to refresh their page to see the refreshed data values on the screen. 

I have some questions here:

1. In a dream world, the user would press a button to refresh the Import Query (Power Flow) and they would see the updated values without all sorts of messing around and wondering in between those 2 points. What is the best way to get to as close to this as possible, without using Direct Query. DQ is off the table as PBI tells me it won't accept Translations in SQL. 

2. I noticed that the Automatic Page Refresh button isn't available on my report without having a Direct Query somewhere on the report. I was wondering if I can perhaps hack the system by putting 1 dummy DQ on the report, which then gives me access to Automatic Page Refresh, which I could set for say every 5 seconds. Would this work?

3. I am on PPU workspace and account. I have read that it is only possible to do 48 refreshes per day. Is this accurate? I have read that there is a Power Automate license Per User available, but it's confusing to me what this actually gets you. Is is possible to license users to be able to refresh the Flow with Power Automate from a button embedded in the report (as I have in my report) as many times as they like throughout the day? What is the cost of this?

4. I have since been able to run a SELECT SUM, COUNT etc through direct query in the database. I was sure I wasn't able to run this previously due to an error saying that Translations aren't supported. Has this feature been added for DQ?

TIA 🙂