Error while refreshing the data

[TiwariNeha]

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

[Anonymous]

Hi,

        When you refresh first time in the service, whole dataset will refresh get refreshed. On second time only, the incremental refresh will work. 

Thanks,

Shanthakumar

[v-angzheng-msft]

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://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-...

https://community.powerbi.com/t5/Service/Power-Bi-Service-Refresh-timeout-expiration-issue/td-p/1648...

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.

[aj1973]

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.

[TiwariNeha]

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.

[aj1973]

@TiwariNeha 

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.

[Fowmy]

@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.