There could be a few reasons why your custom SQL query is causing Power BI Report Server to get stuck at the "Load(Evaluating)" stage.
First, make sure that your SQL query is syntactically correct and does not contain any errors. You can check this by running the query directly in Oracle SQL Developer or another SQL tool and making sure that it returns the expected results.
Next, check the size and complexity of the data being returned by your query. If the query is returning a large amount of data or contains complex calculations, it may take a long time to load into the Power BI model. In this case, you may want to consider optimizing your query or breaking it down into smaller, more manageable parts.
Another possible issue is related to the data types and formatting of the data being returned by your query. Make sure that the data types match the expected values in your Power BI model, and that any dates or other formatted data is properly formatted to be recognized by Power BI.
Finally, you may want to check the performance of your system and network connection to ensure that there are no bottlenecks or issues that are causing the slow load times. If your network connection is slow or there are other issues with your system, it can cause Power BI Report Server to become unresponsive or slow to load data.
If none of these solutions work, you may want to contact Power BI support or your IT department for further assistance. They may be able to help you identify and troubleshoot any issues that are causing the slow load times.
