Forum Discussion

garfieldhe's avatar
garfieldhe
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Failed to refresh

Hi team, my report keep failed when refresh since June 9th till now.   Here is the detail, any suggestion what should I do? Thank you in advance!   Data source error: {"error":{"code":"DM_GWP...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi garfieldhe ,

1. On the Power BI side, you could set timeout option and check again. The maximum is 2 hours.

 

2. On the SQL side, you could use SSMS to check if there is a lock on one or more tables.

    If your data is large, you could create views to optimize data size. 

    It is recommended to update the Connection Timeout and Command Timeout parameters in the relational Target Connection.

 

 

Best Regards

Lucien