Forum Discussion
request time out when entering azure sql database
Hello all,
I created a parameter for the server and database to switvh between dev and production. After publishing on power BI service, and entering credentials of prod DB, the request timed out since it took more than 120 mins to load.
What can I do to reduce the database?
1 Reply
Hi, CarlaGh
You can try to change the command timeout in Advanced options of Data source settings directly.
Please refer to this similar post for more information.
Timeout Refresh errors azure sql sources; refresh time range 15 to 180 min? How to diagnose?
Related links:
https://docs.microsoft.com/en-us/powerquery-m/sql-database
azure-sql/database/performance-guidance
Best Regards,
Community Support Team _ Eason
