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...
Datarefresh takes 15 min and If I increase DTU in my cost will double. (Thats the way current Azure DTU pricing model is) . I am not aware if I can programatically increase DTU in azure for 20 min and bring it back
Problem also can be solved if there are ways to refresh for each table in sequence or if i can set separate refresh schedule time
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.