"The table is empty" in Power Query

[ELIU]

My report has been pulling data from our on-premis Oracle database for the past 6 months and the data flow has been working properly. However, today I've noticed two things:

1, when I clicked on the Source in Applied Steps, it gives me this The table is empty error. The query has been working for 6 months so why is that?

2, The report on the Power BI service has been spinning. Some pages loaded after it spinned for a while, but most pages just kept spinning. Does this relate to #1 above?

Or could this be something related to the gateways?

Thanks!

[v-zhengdxu-msft · Accepted solution]

Hi @ELIU 

Ensure that the Oracle database is up and running without issues. Sometimes, maintenance or network changes can affect connectivity. And make sure there's no network issue that's preventing Power BI from connecting to your Oracle database. If there have been any recent changes to the query, consider reverting them to see if that resolves the issue.

Since you're pulling data from an on-premises Oracle database, ensure that the on-premises data gateway is up and running. A malfunctioning gateway can cause data refresh issues, leading to spinning reports. If the gateway is functioning correctly, consider looking into the report's performance. Large datasets, complex calculations, or inefficient queries can slow down report loading.

Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

Troubleshoot report performance in Power BI - Power BI | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.