The XML for Analysis request timed out before it was completed. Timeout value: 18000 sec

[amal_01]

I have created a Power BI report. I got the data from OData.

I published the report to the Power BI service and refreshed it, but an error appeared.

After multiple failed attempts, the last message was:

"The refresh operation failed because it took too long to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets."

How can I solve this issue, even when I used incremental refresh, I still get the same error?
How can solve this issue even when i used incremental refersh it still same error 

[Anonymous]

Thanks for the reply from lbendlin.

Hi @amal_01 ,

Have you solved your problem? If it is solved, please share your solution and accept it as solution or mark the helpful reply, it will be helpful for other members of the community who have similar problems as yours to solve it faster. Thank you very much for your kind cooperation!

Best Regards,
Zhu

[lbendlin]

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

Note that unless your data source supports query folding the above mentioned bootstrapping method will not help much as your indiviual partition refresh will still exceed 5 hours.

Instead of incremental refresh consider using dataflows (WARNING: These have no time limit) or static extracts for your "cold"  and "warm" data and the OData query for the "hot" data.   (If the data changes frequently in the cold partitions then incremental refresh is not for you anyway).