Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Preventing power bi from disabling refresh

I see the following for one of my datasets, which is not consumed as a report but has massive downstream dependencies.   It works as a SSAS datasource table for a lot of my reports.   Since P...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

FYI that learning Power Automate is easier than Power BI, and this is a pretty simple application. The refresh triggered from the Flow would be independent from your scheduled refresh (but you should set them to run at different times).

 

Pat

 

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

mahoneypat if I set up the Scheduled cloud flow via PA to run to refresh a dataset at a different time than the PBI's scheduled refresh, is there any chance at all that PA can terminate the task (decide not to run the flow to refresh the dataset) based on whatever reason (same like PBI decides Due to inactivity, your scheduled refresh has been disabled. ) I have extremely high dependency on this dataset not missing a single refresh.

 

Please let me know if PA can ever throw such tantrums.

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    What are your downstream dependencies that are not showing up as activity against the dataset?

     

    A few ideas to consider:

    1. Set up a subscription to a report using the dataset for daily/weekly to ensure activity.

    2. Make sure refresh failure notification is set up to email you. You could also set up a Dashboard with a simple visual (row count, refresh date, etc.) and put an alert on that to get notified at each refresh for success or failure.

    3. Set a flow that calls the refresh API daily/weekly to get last refresh datetime of your dataset, so you get notified if not recent enough.

     

    Pat