Forum Discussion
could not load data for this visual
Anonymous
For timeout error, you may have to try different duration to test the connection timeout. See details here - https://docs.microsoft.com/en-us/powerquery-m/sql-database
Example:
Source = Sql.Database("Servername", "tablename", [option1, option2, ConnectionTimeout=#duration(0, 0, 20, 0)])
or
Source = Sql.Databases("Servername", [option1, option2, ConnectionTimeout=#duration(0, 0, 20, 0)])Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous , Are you using cloud database, which you have access to on power bi service and not on desktop?
What is a database and how are you connected with it.
amitchandak I am using sql server database, its not working properly with desktop direct query mode. same works fine after I published and using that in app.powerbi.com