Forum Discussion
Power ParticipantPPU workspace refresh timeout limit
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.
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.
- Jeanxyz
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.