How to Refresh Power BI Reports Based on Values in an Excel File?

[prabavathym]

Hi everyone,

I need help figuring out how to set up a system to refresh specific Power BI reports based on conditions in an Excel file. Here's the scenario:

I have an Excel file with two columns:

Report Name: Names of the Power BI reports.
Schedule: Either Yes or No to indicate whether the report should be refreshed.
My goal is:

Check the Excel file to see which reports are marked as Yes in the Schedule column.
Refresh only those reports in Power BI, leaving the others unchanged.
I’m open to different approaches, whether it’s using Power Automate, custom scripts, or another tool.

Has anyone done something similar or have suggestions on the best way to achieve this? Any examples, guides, or tips would be greatly appreciated!

Thanks!

[uzuntasgokberk · Accepted solution]

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]))
)
"

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[v-jtian-msft]

Hi,@prabavathym .

Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
For example, relevant code or links to articles.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.

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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jtian-msft]

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

[prabavathym]

Hi @v-jtian-msft ,

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.

[uzuntasgokberk · Accepted solution]

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]))
)
"

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[prabavathym · Accepted solution]

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!