Forum Discussion
Time-out issues with Excel against a semantic model
We are seeing time-out issues when connecting Excel with our PowerBI instance. We have Excel connected to a semantic model which in turn points to BigQuery and after 10 minutes of inactivity, somethi...
Akash_Varuna
Super User
Super UserHi Anonymous Try these please .... Myabe it might prevent timeout or reduce it
- Adjust Gateway/Model Timeouts: Increase timeout settings in Power BI or the gateway.
- Use a lightweight query to maintain the connection.
- Optimize Queries: Simplify measures and ensure queries fold efficiently to BigQuery.
- Consider DirectQuery: Switch to DirectQuery for real-time access if feasible.
- Check Network Settings: Ensure no network disruptions or latency issues.
If this post is helped you please do give a kudos and accept this as a solution
Thanks In Advance
Hello, thanks for the quick response. To give some more details, we are using direct query to retrieve the data from Big query but no gateway is involved because we are going directly from PowerBI to Google. The issue is between Excel and the semantic model so has little to do with the queries. We can also discount network issues as the issue happens in different locations and we can get it to fail each time.
How do you think we can implement a simple query to keep the connection up? We currently do a refresh every 9 minutes but during the refresh Excel freezes, meaning other worksheets hang.
Where can we find time-out for the semantic model?