Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.