Forum Discussion
Helper IIHow to Refresh Power BI Reports Based on Values in an Excel File?
Hello prabavathym ,
You can implement via Power Automate. There is a node "Run a query against a dataset" in Power Automate. İn you case it is suitable. For example you can write the a query and make conditional based on your case.
"
EVALUATE
ROW(
"name",CALCULATE(MIN('yourtable'[yourcolumn]))
)
"Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |Hi uzuntasgokberk ,
Thanks for the suggestion! I’ll give the "Run a query against a dataset" node a try and see how it works for my scenario. Appreciate the help!
Hi,uzuntasgokberk ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hi,prabavathym .I am glad to help you.
I found uzuntasgokberk 's advice helpful and I've made some additional additions for him below.
If you would like to learn more about the exact process of creating a Power BI auto refresh using Power Automate, I hope the following links will be helpful to you
URL:
Dynamically Refresh Power BI Datasets with Power Automate
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Helper IIHi Anonymous ,
Thanks for the additional suggestions and resources! I appreciate you for sharing those links. I’ll check them out and let you know if I have more questions.