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
