Forum Discussion
Error in Gateway while data refreshing - There was an error when processing the data in the dataset
Hello All, I am receiving an error in service for data refresh ( while doing On-demand and schedule refresh) Error - There was an error when processing the data in the dataset. Data Source error -...
v-chenwuz-msft
Community Support
Community SupportHi prasad08mm ,
I think the problem is some limitations cause this to happen.
Limit of 1 million rows returned on any query.
Using DirectQuery in Power BI - Power BI | Microsoft Docs
Maybe you can remove some visualizations or just let one page with one visualization and try refresh again.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.