Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.