Forum Discussion
Dataset Refresh Error Incremental
Hi MH3
This seems to be a problem that many users encounter when using incremental refresh.
Here are some suggestions to help you troubleshoot the issue:
1. Verify query folding. For more detailed information, please refer to: Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Docs
2. Rebooting the server cleared it up.
3.reinstall the latest version of the gateway.
Several users also encountered the same problem as you, and they successfully solved their problems, the posts are for your reference:
Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Power BI Community
Solved: Gateway Mashup Data Access Error - Microsoft Power BI Community
Solved: Re: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Power BI Community
Incremental Refresh - Microsoft Power BI Community
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, v-yadongf-msft
In Power BI Desktop, there was an M-Query warning but nothing else.
I am able to see the Native Query of that table, which means query folding is available and then I applied Incremental refresh onto that and published to Service but after pressing refresh again its just taking the whole time which the full refresh takes up.