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]

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:

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