Forum Discussion
Trigger full refresh on a dataflow with incremental refresh
I have a dataflow with incremental refresh activated. Every once in a while, I need to perform a full refresh and overwrite all the data. I could not find a direct way of performing this action in the GUI, so I turned to the API Refresh Dataflow
There is a parameter that could be useful: ProcessType = Type of refresh process to use
However, the documentation falls short of providing a list of supported values.
I tried 'full'. It was accepted but triggered a default refresh - i.e. incremental.
Has anyone information on supported values and whether it is possible to trigger an ad-hoc full refresh ?
5 Replies
Hi bdarbo78
I found this while digging through in Microsoft Power BI's github.
I believe the keyword you are after is "processFull"Line 7745
Regards,
SaiThis command DID NOT trigger a full refresh for me, just a standard one:
Invoke-PowerBIRestMethod -Url /groups/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/dataflows/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/refreshes?processType=processFull -Method Post -Body "{""notifyOption"": ""MailOnCompletion""}"Any other suggestions? Thanks.
Yup, processType=processFull runs a regular refresh for me as well.
Hi bdarbo78 ,
It seems that you want to turn off incremental refresh for your dataflow. Please refer to option in https://docs.microsoft.com/en-us/power-query/dataflows/incremental-refresh#configuring-incremental-refresh-for-dataflows to turn off or turn on incremental refresh for your dataflow.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi All, im facing the same issue did anyone manage to get a full refresh done on a DF thats set to incemental? thanks
