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.
this is an ongoing problem. First I noticed this was that scheduled updates would not complete. This only happens with the biggest reports (900meg+). i had some luck running the update on the desktop but recently I have a report that has failed after over 10 tries. message is always the same:
Sometimes it happens when I change the sql for the report and most of the time it happens after its already processed over 12 million records and should be finishing up so I can save and post it.
Any help in resolving this would be great
error message follows:
DataSource.Error: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Details:
DataSourceKind=SQL
DataSourcePath=afsqlvm1.eastus.cloudapp.azure.com;AFDW
Message=Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Number=-2
Class=11
Solved! Go to Solution.
Found an index that was dropped that matched the where clause of the sql. It did complete after that. So the solution was to check for missing or inefficient indexes.
Found an index that was dropped that matched the where clause of the sql. It did complete after that. So the solution was to check for missing or inefficient indexes.
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.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |