Forum Discussion
Data Refresh Fails
I am using PowerBI pro subscription. Our report takes data from 5 different tables/views from Azure SQL DB. When i refresh these table oen by one, the data gets refreshed without any problem. but aut...
I will check yout suggestion to check on using REST API Operations for Azure SQL Databases with Azure standrd S3/S4/S5
Thanks
Have you tried increases the Timeout duration on your queries?
As an example, here is some code when i run a stored procedure:
= Sql.Database("MyDataBase.database.windows.net", "SQL-DW-PROD", [Query="Exec [TheDatabase].[sp_TheQuery]", CommandTimeout=#duration(0, 1, 30, 0)])
In this example i've made the timeout a 90 minute window.