How to get Power BI report to Refresh automatically?

[PowerUser2000]

Hello, I am trying to get my Power BI report to automatically refresh once the report date in the dataset connected equals the last day of the previous month. The data lives inside Snowflake, and I was thinking of using Power Automate to do this but I don't know how. Any ideas on how to achieve this. I want to try and avoid using the Snowflake connector as well.

[v-priyankata]

Hi @PowerUser2000 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @PowerUser2000 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @PowerUser2000 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[danextian]

For simplicity's sake, why not just create a flow in Power Automate that refreshes a semantic model every first or last day of the momth?

[govind_021]

Hi @PowerUser2000 
You can use Power Automate to schedule a flow that triggers on the first day of the month. Build the logic using SQL queries within Snowflake, fetching data for the previous month. Then configure a refresh action for the Power BI dataset via its REST API. No Snowflake connector needed!

Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst

[lbendlin · Accepted solution]

Reports don't refresh. Semantic Models refresh.

In Power Automate create a scheduled flow for daily run. In the flow run a DAX query against the Semantic Model that checks if your criteria is met.  If yes, do the next step.Not sure what that is - do you want to export the report or something else?