Forum Discussion
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 Power Bi is deciding on its own to disable the refresh, it is messing up all the downstream reports. How can I prevent Power bi from not taking that decision at all?
5 Replies
Hi smpa01
This is a known issue if I remember correctly. Have seen it in our environment as well.
Have you looked at using Power Automate to trigger the dataset refresh?
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Anonymous good suggestion for Power Automate.
But I have not worked with PA that much and I really don't want to start on a PA learning curve unless I absolutely have to.
While we are here, mahoneypat does setting a Scheduled cloud flow in PA need me to switch off the scheduled Power BI refresh? and what if PA flow fails, do I need to set a notification for that? What if I don't turn off PBI scheduled refresh, does both refresh go through?
The easier solution is to be able to overwrite PBI's refresh disabled capacity within Power BI.
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
