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.
We have a Power BI Desktop (Optimised for Report Server File) report built and have uploaded it to our Power BI Report Server. The report talks to our Oracle SQL Database. If I refresh the report directly from the desktop file, the report will update and bring in any changes.
I've attempted to try schedule this refresh on the report server however get the following error:
"Timeout expired. The timeout period elapsed prior to completion of the operation. The exception was raised by the IDbCommand interface"
My confusion is that when testing the Data Sources, our Oracle connection with our authentication when clicked 'Test Connection' brings back 'Connected Successfully'. The only other observation is under 'Scheduled Refresh', the 'Status' stays stuck at "Started Data Refresh" and doesn't change regardless of the page being refreshed.
Does anyone have any ideas? Confusing me as the report refreshes locally and connection should work but the scheduled refresh fails
The lack of support on topics like this is astounding. I get much better support from reddit than i do here. The report refresh timeout settings do not seem to actually do anything.
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 |
---|---|
9 | |
5 | |
4 | |
3 | |
2 |
User | Count |
---|---|
11 | |
11 | |
7 | |
3 | |
2 |