Forum Discussion

New Member

7 years ago

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...

Community Champion

7 years ago

Incremental refresh is only available in Power BI Premium.

What happens if you scale up your Azure SQL DB?

https://stackoverflow.com/questions/26782235/autoscaling-azure-sql-database

schedio
New Member
7 years ago
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
- schedio
  New Member
  7 years ago
  I will check yout suggestion to check on using REST API Operations for Azure SQL Databases with Azure standrd S3/S4/S5
  
  Thanks
  - Anonymous
    Not applicable
    7 years ago
    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.