Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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

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.

-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.

Frequent Visitor

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

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

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,,,






Community Support
Community Support


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.

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Kudoed Authors
Users online (1,316)