Forum Discussion
Error while refreshing the data
Hi All,
I am trying to use incremental refresh for the huge dataset consisting of around 80 Million Records. I have pro license. I am able to publish the report (Configured Incremental Refresh ) but for the first time when i am trying to refresh the complete report, it shows below error :
I am using AWS Redshift with odbc connection as my backend dataset. Can anyone suggest any solution for the issue. Its urgent.
Thanks & Regrads:
Neha
6 Replies
TiwariNeha
In the Power BI Service, Can you check Settings > Manage Gateway > if the Gateway connection is working, you
test the connection there and find out if any issues exist such as credentials etc.Hi TiwariNeha
80 million records seems more than enough to surpass the size allowed for your dataset. What's the size of your dataset? After refreshing your report in your desktop, if your Pibx file is over 1GB of size then with a pro License it won't work.
Hi aj1973 , My dataset size is 630 MB. there is no issue while publishing it , but when i try to do the full refresh for the first time i get timeout error after 2 hours.
Indeed, if the full refresh makes the size of the dataset exceed the 1GB allowed for a Pro license then the Gateway will through a Timeout
Try a full refresh in your desktop to confirm.
Hi, TiwariNeha
Here are some references that might help
https://community.powerbi.com/t5/Service/Dataset-Refresh-Failing-due-to-Timeout/td-p/827944
https://community.powerbi.com/t5/Service/Refresh-Failing-Timeout/td-p/331492
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
