Data Refresh Fails

[schedio]

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 auto refresh schedule fails as POWER makes request (I assume) to all these tables/views simultaneously and it give error request time out (PowerBi and data source both on Azure cloud).

When i check my consumption of SQL server it shows peaking when Power Bi schedule requests the data.

I there any way  

a)  To schedule these tables separately or make PowerBI request refresh one by one ?

b) Is there any way to append the increamental data to PowerBI database (I have PowerBI Pro) 

[Greg_Deckler]

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]

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]

I will check yout suggestion to check on using REST API Operations for Azure SQL Databases with Azure standrd S3/S4/S5

Thanks

[Anonymous]

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.