How can I pass the expression in Run a query against a dataset

Question

In previously we are using on power bi button clicked(trigger) . When we want to trigger the power automata we are going to power bi and click the Run flow(button). Behind these button there will be have three columns and we have to apply filters (year,month) dynamically can we give these kind of scenario in expression or only in dynamic content .can you provide the solution for these scenario i want trigger my power autometa daily not manually it will trigger automatically

Answer 1

@Vijay Thanks for reaching out. You can leverage the reoccurrence trigger and schedule it as per your business needs. Now your power automation workflow will automatically trigger based on your configured you have defined. Now as per you need you can leverage the functions to calculate the year month part directly using the date and time function.

For any power automation query, you can always reach out to the expert here as power automation is not supported in Microsoft QnA