Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incremental refresh report first refresh

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...
  • v-kkf-msft's avatar
    5 years ago

    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.