Hi @hasfour, unfortunately you are always limited to the 8 refreshes per day, if you use the Scheduled Refresh, Power BI REST API, of Power Automate (unless your workspace is in Premium capacity, but I guess you figured that out already).
You last remark did trigger me, because you say:
I am not able to use Directquery or liveconnection with my actual datasets as i am connect to a raw SQL database.
I'm not sure how this would refrain you from using DirectQuery? Could you elaborate on this a bit more? Do you mean by using DirectQuery you lose certain functionality in DAX or are you facing any of the other limitations?
Did I answer your question? Mark my post as a solution!
We are using the report to monitor our service center requests (Dashboard in big screen). We need to refresh the dashboard/report more frequently and 8 times per day is truly not suitable for us.
Further, we have built a report recently by using a SQL database and we do not want to rebuild the report using DWH and Cubes (Live connection) unless its really necessary. Live connection offers the option to refresh the dataset every 5 min (more frequently).
We are trying to find an alternate way based on our actual report connection, that's why I was thinking about Power Automate.
We can still click every time on the Refresh button in Power BI service but that is not efficient. We were also thinking about writing a script to auto-trigger the Refresh button in Power BI service.