Forum Discussion

Krish89's avatar
Krish89
Icon for Helper II rankHelper II
6 years ago

Power BI Dataset refersh failing with the error “Microsoft SQL: Execution Timeout Expired"

Hello Power BI Community, I am getting the error when refreshing dataset in Power BI service with the following error message. “Data source error: Microsoft SQL: Execution Timeout Expired. The time...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Krish89 ,

 

Does your report have parameters? Try to check the parameters.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Krish89's avatar
Krish89
Icon for Helper II rankHelper II
6 years ago

Hi v-lionel-msft ,

 

Yes we have two parameters in the report for incremental refresh(RangeStart and RangeEnd)

 

Regards,

Krishna

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Krish89 ,

     

    There is a problem with the two parameters you created, please refer to the documentation.

    RangeStart and RangeEnd parameters 

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.