Data Load/Refresh Stuck on "Evaluating..."

[SH-4]

Has anyone found a working solution for having the desktop app not able to finish loading in data that previous worked fine? This issue only occurs when connecting through a VPN, but works completely fine with connecting to the on-site network. Everything worked fine on VPN until I visited my site and my laptop connected to the on-site network. After that, I have been having this issue on VPN ever since.

What we've tried/discovered so far:

• It appears to only get stuck on "Evaluating..." when trying to load custom Oracle database queries. However, troubleshooting with our Oracle team showed that there was not any issue actually connecting to the database. so there does not appear to be a firewall issue
• Additionally, we have tried updating the Power BI desktop app & the oracle connection to Power BI... neither have helped solve the issue.
• This happens when trying to load/refresh both one at a time or all at once.
• There is plenty of memory/RAM on the laptop (3/4 space remaining)
• Clearing the PowerBI cache did not change anything
• Adjusting the queries (that work fine for others & work fine when connected to the on-site network) did not hel
• Other connections (Sharepoint, Azure..) load in without issue.

Our IT network keeps wanting to check our Power BI workspaces, despite the workspaces not having any issues at all. So I'm trying to reach out here to see if anyone else has had success with resolving this issue so we can suggest new/different things for IT to try rather than them spending several weeks checking something unrelated and working perfectly.

[CMugacha]

Hi - Were you able to resolve this? I am having the same issue and it started after I opened a recovered file. Thanks

[SH-4 · Accepted solution]

Yes! What ended up resolving this was adding these two lines of code to the sqlnet.ora file

BREAK_POLL_SKIP=10000
DISABLE_OOB=on

[dhnichols]

I do not appear to be using the sqlnet.ora file... that file is only found in the "sample" subfolder of admin... does it need to be applied to the tnsnames.ora file? or move the sqlnet.ora into the admin with this adjustment?

[SH-4]

We were also not actively using that file. You can just move your sqlnet.ora file into the Admin folder with those lines added and it should *hopefully* work for you! 

[CMugacha]

Thank you!! That fixed it for me.

[SH-4]

Yes. It is typically set to "Default" but trying it with "One (disable parallel loading)" does not seem to have an effect on the issue

[christinepayton]

Hmmm... if I recall the only other time I've had this happen is trying to refresh when the source table is locked by another process. Does it load when you refresh in the query editor? Usually you get a more descriptive error in there. 

[SH-4]

Yep everything loads perfectly fine in my query editor. I only see this issue when I "Close & Apply" and unfortunately it never moves past "Evaluating..." to even give me an error. It will literally stay on that for hours if I let it

[christinepayton]

Have you tried turning parallelism off? https://blog.crossjoin.co.uk/2019/03/26/power-bi-caching-parallelism-and-power-query-refresh-perform...