Forum Discussion
PPU workspace refresh timeout limit
we recently published a report to a PPU workspace. Usual dataset refresh takes 20 minutes, but there are some problem with source data at Jira side, as a result, the refresh in PPU workspace is prolonged to 5 hours. Is there anyway to reduce the timeout limit to 1 hour? There is no way to check the report while the refresh is taking place.
Thanks, but none of them work in my case.
The real problem is with source data at Jira, the import query is very simple, only 2 steps, imported table only contains 150 rows, so the suggestion above won't help. I have also tried reducing the timeout duration in the import query to 5 minutes, but long refresh issue retains.
source =Json.Document(....,[Timeout=#duration(0,0,5,0)]))
So as a temporary solution, I moved this problematic table into a seperate data flow and refreshed that table only once a day at non-peak time. If the refresh fails, it only impacts the data flow, the other tables in the Power BI data model still get refresh multiple times a day.
2 Replies
Hi Jeanxyz
The Power BI cannot customize the timeout limitation. you can refer to the following suggestion.
1.If your data is too large, you can consider to use incremental refresh if your data source support it, it can improve the refresh speed, you can refer to the following link.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
2.You can consider refactoring the large semantic model into multiple smaller semantic models.
3.You can consider to change the import mode to direct mode,it connected to the data source directly, it can optimize the model.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but none of them work in my case.
The real problem is with source data at Jira, the import query is very simple, only 2 steps, imported table only contains 150 rows, so the suggestion above won't help. I have also tried reducing the timeout duration in the import query to 5 minutes, but long refresh issue retains.
source =Json.Document(....,[Timeout=#duration(0,0,5,0)]))
So as a temporary solution, I moved this problematic table into a seperate data flow and refreshed that table only once a day at non-peak time. If the refresh fails, it only impacts the data flow, the other tables in the Power BI data model still get refresh multiple times a day.
