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.
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,,,
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.