PBI Stuck in evaluting, but in pq the data is loaded

[Anonymous]

Hey everyone,

I came across a very unusual situation in PBI, I have a connection to a oracle database everything was working fine until the last couple of weeks.

The problem is:

In powerquery the data is loaded fine (Test with only 4 rows):

But when i apply the changes it get stuck in this screen:

+1 hour and waiting... only 4 rows to load and still nothing.

The same 4 rows in dbeaver takes less than 1 sec to return:

 

I have already tried:

1. Uninstall PBI/Reinstall PBI
2. Restart the PC
3. Unchecked the second plane load
4. Clear PBI Desktop cache
5. Refresh all queries in preview
6. Clean cache then refresh all in preview
7. Disable privacy check for the report
8. Check all your path locations under "Data source settings"
9. Downgrade PBI to version PBIDesktopSetup-2021-10_x64/PBIDesktopSetup-2021-07_x64

And still nothing happens...

Links that I already looked into

https://community.powerbi.com/t5/Desktop/Data-Loading-Fine-in-Power-Query-but-not-Loading-in-Power-B...

https://community.powerbi.com/t5/Desktop/Applying-Queries-stuck-with-Creating-Connection-Model/m-p/5...

https://community.powerbi.com/t5/Issues/Data-refresh-gets-stuck-on-Evaluating-the-first-time/idi-p/5...

https://community.powerbi.com/t5/Power-Query/PowerBI-Refresh-is-stuck-on-quot-evaluating-quot/td-p/1...

https://community.powerbi.com/t5/Power-Query/Long-time-quot-Evaluating-quot-for-no-apparent-reason-d...

 https://www.c-sharpcorner.com/blogs/how-to-clear-cache-of-power-bi-desktop

[Anonymous · Accepted solution]

Solved by reinstalling the oracle client

Thanks for the support

[Anonymous]

Hey @amitchandak 

Thanks for the idea, but still stuck 

C:// free space:

I even reduced the query to bring only one row

I willl check if there is an open issue

Thanks for the link

[amitchandak]

@Anonymous , Increase data management cache to 8-10 GB, it should be supported by RAM and virtual memory

Also, make sure the drive on which power bi is installed is having around 40 GB of free space.

if these do not help, Log an issue at https://community.powerbi.com/t5/Issues/idb-p/Issues

check is there already open issue