Schedule refresh and get data into Flow to loop and send notifications few times a week without "On premise data gateway"

[AC_Flow]

Objective: Schedule refresh and get data into Flow to loop and send notifications few times a week without "On premise data gateway"
Any ideas how to get data refreshed and feed into flow to loop through.

Limitations:
-On premise data gateway is not allowed
-Don’t have premium license
-Have "On premise Power bi server" that i can publish a report and have refresh scheduled
-Excel slq/power query can not be refreshed from flow
-I have my queries with output ready in power query and sql
-I have set up a Flow process that can loop and send emails from static excel data, as i can not refresh excel.
Please advise.

[AC_Flow]

@JohnAageAnderse  FYI, in case you could help or know someone who has overcome above . thks

[JohnAageAnderse]

Hello @AC_Flow 

I read your post and it left me with no understanding of what you need! 🙂

Could you describe how you see your process/steps, what data flows between the steps, without thinking about how to include Flow to automate it?

After your description, it may become clear where automation can be included 🙂

Edited: Then a look at the list of connectors could be useful

Looking forward to your reply, kind regards, John

[AC_Flow]

in short i can not get data into flow that flow can refresh as i dont have on data gateway and flow can not refresh excel SQL or power query queries. ( I dont have premium licence either)

old school. i fell like using pc task scheduler to refresh power query via VBA/Python and flow to pick up and send email,,,

[JulienOlivier]

@AC_Flow 

From what I understand, without the On-Premise data gateway, it will be difficult to have your data refreshed with Power Automate.

I think it must be done not at the Power Automate end, but rather at Power Query end, like you said with Python or VBA.