Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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

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):
ArthurAnzai_0-1642800163039.png
But when i apply the changes it get stuck in this screen:
 
ArthurAnzai_1-1642800195012.png

 

+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:
 ArthurAnzai_4-1642800451139.png

 

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

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Solved by reinstalling the oracle client

 

Thanks for the support

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Solved by reinstalling the oracle client

 

Thanks for the support

Anonymous
Not applicable

Hey @amitchandak 

 

Thanks for the idea, but still stuck 

 

ArthurAnzai_0-1643025813980.png

C:// free space:

ArthurAnzai_1-1643025833547.png

 

 

I even reduced the query to bring only one row

 

ArthurAnzai_2-1643025882473.png

 

 

I willl check if there is an open issue

 

Thanks for the link

 

amitchandak
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.