Forum Discussion
"Apply Query Changes" takes long time
My source is a view from SQL Server, it shows waiting (as below screenshot 1) for long time
Sometime it connects and loads data, sometimes it throws error (as per screenshot 2)
Screenshot 1
Screenshot 2
Even I have the The data source details under ODBC data source Administrator
Need help in resolving this issue
Have you run the query in SQL Server Management Studio and checked if the query runs as expected?
In addition, increase the remote query timeout value in the Server Properties of your SQL Server instance.
And specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can refresh successfully in Power BI Desktop.
1. Click on the arrow for "Edit Queries" in your current Power BI Desktop file, select "Data Source Settings” in the dropdown.
2. Click on "Change Source..." in the Data source settings pop-up window.
3. Click on Advanced Options in the pop-up window, enter 60 minutes in the "Command timeout in minutes (optional)" textbox, then click OK.Regards,
Lydia
1 Reply
Have you run the query in SQL Server Management Studio and checked if the query runs as expected?
In addition, increase the remote query timeout value in the Server Properties of your SQL Server instance.
And specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can refresh successfully in Power BI Desktop.
1. Click on the arrow for "Edit Queries" in your current Power BI Desktop file, select "Data Source Settings” in the dropdown.
2. Click on "Change Source..." in the Data source settings pop-up window.
3. Click on Advanced Options in the pop-up window, enter 60 minutes in the "Command timeout in minutes (optional)" textbox, then click OK.Regards,
Lydia