Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
So I\ve read that when you upload a report that has incremental refresh the first scheduled refresh may take more time to refresh and the ones after the first refresh will be quick.
I have incremental refreshing set up correctly, no errors shown and all seems to be good but in service the first refresh takes so long, first I had manually added timeout to the source for 120 minutes but the refresh took more than that and emailed me that it failed due to timeout, then I increased the timeout to 240 minutes and still got error:
Hide | Scheduled | 18/03/2021, 07:02:24 | 18/03/2021, 09:15:28 | Failed | There was an error when processing the data in the dataset. | |||||
|
How am I supposed to get this to work if this timeout error comes everytime?
Report is obviously in import mode and data comes from SQL server.
Solved! Go to Solution.
Hi @Anonymous ,
I'd like to suggest you increase the CommandTimeout and the ConnectionTimeout parameters to two hours to see if it works. The default value for ComandTimeout is ten minutes and the default value for ConnectionTimeout is driver-dependent. You may go to Power Query to modify them.
In addition, do you use Premium workspace? Here’s the refresh time limitation for a scheduled refresh in Power BI service:
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.
Therefore, I suggest you to upgrade your workspace to Premium workspace if you have started the PPU trail, like this:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I'd like to suggest you increase the CommandTimeout and the ConnectionTimeout parameters to two hours to see if it works. The default value for ComandTimeout is ten minutes and the default value for ConnectionTimeout is driver-dependent. You may go to Power Query to modify them.
In addition, do you use Premium workspace? Here’s the refresh time limitation for a scheduled refresh in Power BI service:
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.
Therefore, I suggest you to upgrade your workspace to Premium workspace if you have started the PPU trail, like this:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.