Forum Discussion
PowerBI incremental refresh - 1st refresh timeout
Hi, I have a current PowerBI report which uses an Import connection to a SQL server. One of the fact tables has ~40Million rows. The report currently sits on the AppService and does a full refre...
Hi. Power Bi Service has a 2 hours timeout limitation. Your data and transformations must refresh in that timeline. Sometimes the databases can't resolve complex queries in short time (adding resources might help), and other times the model size is too big for it. If your query is fast, then try downsizing techniques for the Power Bi data model. You can check details of it with DAX studio with some youtube videos helping there.
If you still have more than 2 hours with the smallest way of the model and the database runing fast, then you have to consider your model too big for Power Bi and start thinking in alternatives like Power Bi Aggregations composite or Analysis Services.
Hope this helps,