Forum Discussion
Data Load/Refresh Stuck on "Evaluating..."
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.
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
15 Replies
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
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.
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
Have you tried turning parallelism off? https://blog.crossjoin.co.uk/2019/03/26/power-bi-caching-parallelism-and-power-query-refresh-performance/
Hi - Were you able to resolve this? I am having the same issue and it started after I opened a recovered file. Thanks
I have not. I do not have experience with code. Not sure what you are referenceing in "Admin folder" or "Sample folder".
I also want to mention that I am not using an Oracle file in my query. I'm using Excel files that are saved on One Drive.
So this isn't necessarily coding, just going into your File Explorer to paste into the text file (example below). But if you aren't using Oracle, you might be having the issue for a different reason. I never had any problems connecting to my desktop One Drive or online Sharepoint, it was just with my Oracle connections. You might need to reach out to Microsoft to see if they might know what's going on
First step = reinitiate your computer. After many trials with complex solutions, it finally worked for me. I know, it's too simple, but saved my mind. Regards.
